Backing Up WordPress Database

As all of us know, your blog’s database is very important, simply because it shops all your blog’s contents along with other information. But what would you do if your WordPress weblog is all of a sudden hacked? Or didn’t improve to the latest model of WordPress?

How do we stop this nightmare to happen? Simple and simple, backup your database frequently. There is a WordPress plugin which can do that, but occasionally we need to know how to backup your WordPress database straight in your phpmyadmin.

I’ll show you how you can do this database backup:

1. Log in for your cpanel or webhost exactly where you have installed your WordPress weblog.

two. Search for phpmyadmin icon and click on this icon. You need to see the lists of one’s database names for those who have more than one. But when you only have one database in your phpmyadmin, then choose that database. Important: make sure that you are clicking the proper database.

In situation you do not know which database title you used to put in WordPress, you are able to always verify wp-config.Php file, and see what database name you used.

3. So i assume you clicked the “correct” database title, you’ll see all the tables of your WordPress blog.

four. In the leading right of one’s phpmyadmin web page, there is a button, labeled with “export”. Click that button.

5. As soon as you hit export button, you need to have the ability to see export dialog box, and which tables you would like to export for your pc. Be sure you verify all the tables, by selecting “select all” hyperlink.

6. Nonetheless within the exact same web page, export dialog box, scroll down, you will see the checklist of file formats you can save your database into.

7. Make certain that “sql” is selected. Then in conserve as file, you can select both.Zip file or leave it as default which is “none” choice is ticked. This may allow you to save your database in sql file extension.

eight. The most essential, click on go button. This button will bring a dialog box exactly where you are able to conserve this file to your pc. Select any folder that you’ll remember.

That’s it, very quick and easy alternative to save and backup your WordPress weblog.

Jerica is an author of WordPress Coupon and Best WordPress Plugin review media.

Processing your request, Please wait....