Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL
Manually Restore WordPress Site From Backup (Database, Files & Folders) | WP Learning Lab

In this tutorial I’m going to show you how to manually restore your WordPress site from a backup. We will restore the database, files and folders.

The free versions of a lot of WordPress backup plugins don’t have an automatic restore function so if you need to restore your website you have to do it manually.

First let’s upload your WordPress website files and folders. Log into your hosting cPanel account and click on File Manager. Open the root of the WordPress website you’re restoring.

Once you’re in the root upload the ZIP file that contains all your WordPress site files and folders. Once uploaded select all the files in your website root, except for the ZIP, and delete them.

Now click on the ZIP file and click on Extract. That will place all the site files in the root directory.

Now let’s restore WordPress database.

Go back into your hosting account cPanel and open the PHPMyAdmin app.

When it loads find your database name in the left hand column and click on it. All of the tables should load in the middle pane. Check the box to the left of all the tables to select them and then scroll to the bottom of the page.

From the drop down select Drop and then click on Go and then Yes on the next page. This will delete your entire WordPress website database.

Now click on the Import tab at the top. Click on the Browse button and find your .sql backup file and click on Open. Then click on Go and your database will be uploaded.

That’s all there is to restoring WordPress and restore WP database.. I hope this information helps you! If you have any questions leave a comment below or ping me @WPLearningLab on Twitter.

source