- Login to phpMyAdmin
- Click on your database name
- Click on the tab labeled EXPORT
- Select all tables you want to backup (usually all)
- Default settings usually work, just make sure SQL is checked
- Check the SAVE FILE AS box
- Hit GO
By Angela Bradley, About.com Guide
©2012 About.com. All rights reserved.
A part of The New York Times Company.