How to Restore WordPress Database from Backup

This video shows you how to restore a WordPress database in 3 easy steps. Visit: http://thatsearchthing.com/fully-rest...

Things Needed Before Starting

A "Zip" program such as WinZip, 7Zip or a built in version that comes with your operating system (Mac or Windows).
Administrative access to your website directories. This video shows a setup with cPanel access.
Administrative rights to your WordPress Installation

Restoring your WordPress files and database can be done in 3 steps:

1. Download Your Backup File
Using the "download" feature in the actions column on the manage backups page. You can get there from within WordPress by going to: Tools Menu, then selecting backups.

2. Unzip the compressed (zipped) File
You will need to use a unzipping program such as WinZip or 7Zip to extract the files. Depending on the size of your backup, this can take some time. My file took about 3 minutes to unzip. When the file has been unzipped, you should see the following:

Your database file (filename.sql)

Note: After I unzipped the files I moved them to a special folder (FTP-Transfers) on my hard drive, which made it easier for me to find those files during the upload. This is optional, I just do it because it's habit for me. As long as you know where those file are on your computer, you can skip this.

3. Restore Your Database with phpMyAdmin

In order to complete the restoration process, you now need to import your backed up database (filename.sql). There are a few ways that you can do this. In this video I do it Using a tool called phpMyAdmin, which is a utility that's available within my cPanel in my website install from my hosting service.

Note: There are similar tools like phpMyAdmin, as well as stand alone desktop tools but you are still going to need to know your ID's and passwords to access the folder where your database is stored. Here is an article that can help explain what's available for restoring MYSQL databases.

To use the phpMyAdmin application this is what you need to do next:

In the cPanel locate phpMyAdmin application and double click the icon

Login to phpMyAdmin (ID and Password will be needed)

Click databases tab and select the database that you want to restore. Note: for references purposes, you will see a series of tables below, this let's you know you're in the right place.

Click the Import tab and locate the "Files to import" section

Click the "Browse" button (You will get a pop up screen)

Now navigate to the directory on your computer or the location you have stored the backup database. Find the location of of your File (FileName.sql)

Select the database file (FileName.sql) and then click "Open"

Go down to the "Format section, and make sure you have selected the SQL format. Now you can click the 'Go" button and your import will start.

After the import has completed, you will see the following message: "Import has been successfully finished, xxx queries executed. (FileName.sql)"

If your restore should fail, try looking at some these links to troubleshoot your WordPress restore. - https://www.google.com/#q=wordpress+r...

WordPress Restore is also known by these labels:
----------------------------------------------------------------
restore wordpress backup
restore wordpress database
restore mysql database
wp backup restore
restore wp database
restore wordpress from backup
how to restore wordpress
restoring wordpress