Lee Clemmer {dot} com

You can find the full instructions to back up your WordPress database over at Wordpress.org, but here are the settings needed for a phpMyAdmin export (more for my own reference than anything else):

1. Select ONLY those that hold your Wordpress site.
2. Check the “Add DROP TABLE” box.
3. Check the “Complete inserts” box.
4. Check the “Save as File” box
5. Check the “None” for compression. If your database is very large use a compression method.
6. Click Go. The data will now be saved into your computer.