Simple Backup

The following is a very simple version of how to use phpMyAdmin to back up your WordPress database. For more detailed information see WordPress Backups and Backing Up Your Database. Once you have discovered how to access your site’s phpMyAdmin, follow these simple instructions.

Begin by clicking database in your phpMyAdmin panel.

You may have several databases. Click the one that holds your WordPress data, the database you created when you installed WordPress.

This shows only default tables. You may have more tables — this would happen if you have any statistics plugins or anti-spam plugins.

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.

Keep these files safe !