Yesterday I showed you how to backup your WordPress database. Today I’ll show you how to restore your WordPress database.

Here’s what to do to restore your WordPress database using the backups that you have made.

1. Log into your FTP account and delete everything in the /wp-content/cache directory.

2. Log into your PHP MyAdmin and select your WordPress database. It is very important that you choose the correct name of your WordPress database especially if you auto-installed it using Fantastico.

3. You will be presented with a list of all the tables contained in the database. Click on Check All to select all the tables. Then select the Drop option from the drop-down box to delete the tables.

4. Choose Yes and all tables will be deleted.

Now it is time to actually restore your WordPress database.

1. Click on the Import menu and then browse to the location of the backup file. Once you’ve done that, click on go and wait for the upload process to finish.

A successful database restoration will show you a message confirming your success.

Now go to your admin panel and check your site to make sure everything is functioning properly. If it is you have successfully restored your WordPress database!

Popularity: 6% [?]