How to Restore Your WooCommerce Store Files and Database
Restoration of your WooCommerce store is pretty straightforward. We are very sure that if you always maintain a regular backup, you will one day reach a point when you need to restore one of the previously generated backups. If you're not sure how to perform the backup restoration, you are always welcomed to submit a support ticket to us so that our technical team can do this on your behalf.
However, if you are confident you can do this alone all by yourself, please feel free to go ahead by referring to the next few lines of this tutorial.
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.
Assuming you have already backed up all the files related to your store, you just need to transfer all of them into your hosting account. This can be done by using FTP programs such as FileZilla, SmartFTP, FlashFXP etc.
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.
You will encounter "Overwrite" option during the files transfer. Just click on "Always use this action".
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 here.
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 already prepared on your local computer, you will need to access the newly created database via the phpMyAdmin application.
To restore the .sql file, kindly follow this simple tutorial which we have prepared previously for WordPress database restoration.
However, if you are confident you can do this alone all by yourself, please feel free to go ahead by referring to the next few lines of this tutorial.
Step 1: Restore Files Via FTP or File Manager
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.
Assuming you have already backed up all the files related to your store, you just need to transfer all of them into your hosting account. This can be done by using FTP programs such as FileZilla, SmartFTP, FlashFXP etc.
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.
You will encounter "Overwrite" option during the files transfer. Just click on "Always use this action".
Step 2: Restore Database Backup e.g. MySQL
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 here.
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 already prepared on your local computer, you will need to access the newly created database via the phpMyAdmin application.
To restore the .sql file, kindly follow this simple tutorial which we have prepared previously for WordPress database restoration.
Updated on: 04/03/2019
Thank you!