If you need to restore a backup of your PrestaShop database, the steps to restore the database will depend on how you created your database backup. In our article on creating a PrestaShop backup, we discussed three options for creating a backup:

  • Backing up PrestaShop database through the cPanel Backup Wizard
  • Backing up your PrestaShop database through phpMyAdmin
  • Backing up your database in the PrestaShop Back Office

Please see the appropriate are below for information on restoring each type of backup. Before importing your backup, be sure to set Enable Shop in the Preferences tab to no until you have completed the restoration. Once you have restored your database, you can then re-enabled your PrestaShop store.

Restoring a PrestaShop database backup created through the cPanel Backup Wizard

If you created your PrestaShop database backup using the partial backup option in the cPanel Backup Wizard, please see our tutorial on Restoring a MySQL Database from a Partial Backup in cPanel.

Restoring a PrestaShop database exported through phpMyAdmin in cPanel

If you exported your PrestaShop database through phpMyAdmin, please see our tutorial on Importing to a MySQL Database in phpMyAdmin.

Restoring a PrestaShop database backup created through the PrestaShop back office

If you created your PrestaShop database backup through the DB Backup tool in the PrestaShop back office, the backup file is saved in bzip2 format (BZip compression). This file will need to be uncompressed on your local computer before restoring it on the server. A compression utility such as 7zip can manage bzip2 files and can be used to extract the backup on your local computer. Once you have extracted the .sql file from the bzip2 archive, follow the instructions for importing a file into a MySQL database.

If you have any questions about restoring your PrestaShop database, please feel free to submit a question in the Community Support area of the Support Center.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?

Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.