How to Backup and Restore WordPress Database Manually

By techgist, October 15th, 2009 in How-To,Wordpress  |  3 Comments
Advertisement

wordpress_backup

A successful blogger always cares about his database because it means great time to him. It is the most essential part of a blogger to run a periodical backup of the database. If you have not yet installed and activated the WordPress Database Backup Plug-in, we request you to read our other article Important things you must do after WordPress installation and install the back up plug-in. Even though the database backup plug-in is available it is always better to know how to manually backup and restore WordPress Database.

We provide here a quick guide to Backup and restore WordPress Database manually using phpMyAdmin.

Backup WordPress Database

1. Login to your phpMyAdmin and select your WordPress Database.

phpmyadmin_backup1

2. Now click on Export, by default all the tables will be selected for export.

phpmyadmin_backup2

3. You should check “Add CREATE PROCEDURE / FUNCTION / EVENT” option if you are moving your database to another host.

4. The default export file format will be .sql (recommended) and check the “save as file” option and hit go browser; it will prompt you to download and save the file in a preferred location.

phpmyadmin_backup3

5. Now, you have completed the WordPress Database Backup manually.

Restore WordPress Database (New Host)

Restoring your database involves two different methods, If you are moving your database to a different host then follow the below steps:

1. Again login to your phpMyAdmin.

2. Now click on Import and select the exported .sql file and hit go to restore.

phpmyadmin_backup4

3. You can update wp-config.php if necessary.

4. Restoring the database in new host is completed.

Restore WordPress Database (Existing Database)

If you are restoring your WordPress Database to an existing Database then follow the below steps,

1. Again login to your phpMyAdmin and select your WordPress Database.

2. Then go to “Structure” tab and check all tables and select drop and hit go to execute the action. Now all the tables will be dropped.

phpmyadmin_backup5

3. Now, click on Import and select the exported .sql file and hit go to restore.

phpmyadmin_backup4

4. Restoring the database is completed.

When your ideas, trade and business are involved in the blog that you have created doing the above backup procedure will help you to save your precious time.


3 Comments »

  1. Latha — February 24, 2010 at 10:34 am

    Best article about word press backup.Thanks…….

  2. Frankie — August 26, 2010 at 9:36 am

    Excellent! You have saved my blog!

  3. Web Designer — April 13, 2012 at 12:50 am

    Great, thanks for your share!
    @2012-04-13 15:49



Leave a comment