Backing Up WordPress Database
As all of us know, your blog’s database is very important, because it stores all of your blog’s contents along with other information. But what would you do in case your WordPress weblog is all of a sudden hacked? Or failed to upgrade towards the newest model of WordPress?
How do we prevent this nightmare to happen? Easy and simple, backup your database regularly. There’s a WordPress plugin which can do this, but occasionally we need to know how to backup your WordPress database directly in your phpmyadmin.
I will show you how you can do this database backup:
one. Log in for your cpanel or webhost where you have installed your WordPress blog.
2. Search for phpmyadmin icon and click this icon. You need to see the lists of your database names if you have more than one. But when you only have 1 database inside your phpmyadmin, then select that database. Essential: be sure that you’re clicking the right database.
In case you don’t know which database name you used to install WordPress, you can usually verify wp-config.Php file, and see what database title you utilized.
three. So i presume you clicked the “correct” database name, you will see all of the tables of one’s WordPress weblog.
4. In the leading correct of one’s phpmyadmin web page, there is a button, labeled with “export”. Click that button.
five. As soon as you hit export button, you need to have the ability to see export dialog box, and which tables you want to export for your computer. Be sure you check all of the tables, by selecting “select all” link.
6. Still in the exact same page, export dialog box, scroll down, you’ll see the list of file formats you can conserve your database into.
7. Make certain that “sql” is selected. Then in save as file, you are able to select either.Zip file or depart it as default that is “none” choice is ticked. This may enable you to save your database in sql file extension.
eight. The most important, click on go button. This button will bring a dialog box exactly where you can save this file for your pc. Select any folder that you will keep in mind.
That is it, very quick and easy alternative to save and backup your WordPress blog.
Jerica is an author of WordPress Coupon and Best WordPress Plugin review media.