Backing Up WordPress Database Using PhpMyAdmin
WordPress backup can be easily taken by using Import/Export feature in wordpress admin panel easily. But it does not save your blogroll. It also does not save your settings or data some of your wordpress plugins might have stored(such as certain spam plugins). In this case we can use backup database using PhpMyAdmin.
# Click on the database which you want to backup.
This shows only the tables in your database.
# Click on the Export Tab to get this screen :
1 Select ONLY those that are your WordPress blog.
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 in zip format into your PC.
Credit : WordPress Backup
November 22, 2009
One response to Backing Up WordPress Database Using PhpMyAdmin
Pingback: HOMER