How to Backup MYSQL databse using phpmyadmin
Below are the screen shots with steps, 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
This shows only default tables. You may have more tables — this would happen if you have any statistics plugins or anti-spam plugins.
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.
Keep these files safe !
Thats it
Cheers
Admin
Related Articles You Are Probably Interested In:
- Intro About MYSQL
- Review of Backup buddy WordPress blog backup plugin
- How to Import Large SQL Database files using phpMyadmin
- How to clean up your wordpress Blog
- How to backup your wordpress blog including images
- What is wordpress caching
- How to Transfer a WordPress Blog to a new Server
- Could not connect to the database error in WordPress
Leave a Reply
