- 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
Step-by-step advice on how to do everything from choosing a Web host to promoting your content. More >
Easy ways to connect two computers for networking purposes. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.