As we all know, your blog’s database is very important, because it stores all the contents of your blog and other information. But what would you do if your WordPress blog hacked? How do you prevent this nightmare from occurring? Easy and simple, backup your database frequently. There are some WordPress plugins that can do this for you, but certainly you need to know how to backup your WordPress database directly from your PHPmyadmin panel.
In today’s blogging tips session I would like to show you how to backup wordpress database:
1. Log in to your Cpanel
2. Find the icon PHPMyAdmin and click on it. You will see list of database names. Then select the database you want to backup. Important: Make sure that you are clicking the right database name. If you aren’t sure which database the name you used for the blog, you can check the wp-config.php file and see the name of database used.
3. So I guess you clicked on the “correct” name of database, you will see all the tables of your WordPress blog.
4. At the top right of the PHPMyAdmin website, there is a button labeled “Export”. Click that button.
5. Once you click the Export button, then you’ll be able to see the export dialog box and the tables to export to your PC. Make sure to check all the tables, by selecting the “select all” link.
6. Scroll down the export dialog box and you can find a checklist of file formats that can be kept in its database.
7. Make sure that “SQL” is selected. Then, to keep as a file, you can select the file compression method. Zip is default if “no” option is checked. This may allow you to save your database in the sql file extension.
8. Probably the most essential step, click “Go” button. This button will give you a dialog box exactly where you can save this file to your computer.
This is the very quick and easiest way backup your WordPress blog’s database. Good luck!
Backing up the SQL database is never a problem but I face problem restoring it when I transfer my website to different host.I restore the backup but still don’t get my database.Then I talked to Host’s customer support and they told me that I have to also change the SQL login and password in my wp-config file as well and that solved my problem
Yes, changing the SQL login and password in wp-config.php will do the trick. Remember to download your SQL as .zip file rather than .sql file to make sure all the tables are exported correctly.