Updated on Dec 10, 2015
If you maintain a regular backup generation procedure and you reach a point when you need to restore on e of the generated backups then most probably you wonder how to perform the backup restoration. In the next few lines of this tutorial we will provide you with more information on how you should be able to handle the entire restoration process on your own.
Just in case you have no backups generated for your website, our WooCommerce Hosting package provides weekly backups which you can get restored if you simply contat our Technical Support Team.
This step can be skipped if you are sure that the issue you have experienced is related only to the database of your website. In case you would like to restore the files here is what you will need to do.
Considering that you have the files you have backed up previously on your local computer you will need to login into the FTP service for your account using an FTP Client. If you are wondering where to find the login credentials for that service you can check the welcome email you have received after purchasing your hosting package.
Assuming that you have connected to the FTP service for your account you should start uploading the files. We recommend to simply select all of the files from your local computer (by clicking on a single file and pressing key combination of CTRL + A) and upload them by right-clicking on the selected files and choosing the Upload option.
This will prompt a warning that you are about to overwrite some existing files and this is normal since you are uploading the backed up files over the currently existing files. Thus you should choose to overwrite the files by selecting the "Overwrite" option and then the "Always use this action". Next you will need to simply click the "Ok" button so the upload can start.
Once the upload is finished the files will be properly overwritten and with that the restore of those can be considered as completed.
Now that you have restored the files it is time to restore the database. For this to happen first you will need to have a brand new database, username and password which you can receive following our Create cPanel Database tutorial.
Once you have a database name, username and a password you are ready to proceed with the restoration. Since you most probably have the .sql file you would like to restore prepared on your local computer you will need to access the newly created database via the phpMyAdmin application. It is accessible under the Databases section of your cPanel, thus you should be able to find it easily once you login into the cPanel service for your account.
There you will need to find the database name in the list of databases positioned vertically in the left section of the page you will be presented with. Once you access the database you will see no tables or data in the same and because of that you will need to simply click on the Import button. If you see some tables when you access the database please make sure that you are accessing the correct database as the one you have just created should not have any tables.
The Import button will redirect you to a new page where you will be able to find the Choose File button which you should use in order to point the .sql file you would like to be restored for your database from your local computer. Once this is achieved please click on the Go button so the file can be uploaded and then imported into the new database.
The process should be completed with a message indicating that the import was successful.
You are almost done! Now that you have both the files and the database restored the final thing you will need to do is to simply connect the restored version of your website with the restored database. This is quite easy for achieving and the only thing you will need to do is to edit the code of the wp-config.php file.
In order to edit the code of that file you have quite a lot of options but lets review the most easiest one. In your cPanel you will find a feature called File Manager. Click on the icon for this feature so you can access the folder where Wordpress is installed and whrere the wp-config.php file can be found. Once you see the file please right-click on the same and choose the Code Edit option.
Now that you see the code of the file you will need to search for the following line:
define('DB_NAME', 'example_database'); /** MySQL database username */ define('DB_USER', 'example_username'); /** MySQL database password */ define('DB_PASSWORD', 'someStrongP@SSw0rd!');
Here you should change the code appropriately and put the database name, username and password of the newly created database which you have imported the .sql backup file into. When you are ready simply press the Save Changes button located at the top right corner of the page so you can save the changes and finalize the whole restoration process.
Congratulations! You have successfully restored a complete backup for your WooCommerce Online Store!