Backing up your WordPress database
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):
- Select ONLY those that hold your Wordpress site.
- Check the “Add DROP TABLE” box.
- Check the “Complete inserts” box.
- Check the “Save as File” box
- Check the “None” for compression. If your database is very large use a compression method.
- Click Go. The data will now be saved into your computer.
Tags: backup, database, export, phpMyAdmin, wordpress