Child pages
  • Database Backup

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.



You must perform regular backups of your shop, so that in case of a crash, you can reboot your shop quickly and in the best conditions. The database contains all most of the information in your shop, many of which are indispensable for PrestaShop to work correctly – including your products, categories, and other data you added since the installation, but not your images for instance (these are stored, along with your theme files, on your server).

The more often you perform a backup, the safer you are. Once a week is a minimal frequency.


  • The "Disclaimer" section gives you a series of reminders about backups, which you should read every time you make a backup. The section ends with the "I have read the disclaimer, please . Please create a new backup" button, which you have to click in order to create a backup. Once created, the backup appears in a new "Download section" at the top of the page (click the button in order to download the backup file to your computer), and in the list below the notices.
  • The "How to restore" section gives you tips on how to get your data back into PrestaShop in case of failure. You should commit this to memory, or at least save this information somewhere in case a database crash makes it impossible for you to access the PrestaShop administration – and thus the DB backup page – again. Just in case, you will find it below as well.

titleHow to restore a database backup in 10 easy steps
  1. Set "Enable Shop" to "No" in the "Maintenance" page under the "Preferences" menu.
  2. Download the backup from the list below or from your FTP server (in the folder "admin/backups").
  3. Check the backup integrity: Look for errors, incomplete file, etc... Be sure to verify all of your data.
  4. Please ask your hosting provider for "phpMyAdmin" access to your database.
  5. Connect to "phpMyAdmin" and select your current database.
  6. Unless you enabled the "Drop existing tables" option, you must delete all tables from your current database.
  7. At the top of the screen, please select the "Import" tab
  8. Click on the "Browse" button and select the backup file from your hard drive.
  9. Check the maximum filesize allowed (e.g. Max: 16MB)
  10. Click on the "Go" button and please wait patiently for the import process to conclude. This may take several minutes.


The table below the notices lists all the backups that have already been made, indicating the date of creation, age, file name, and size.
At the right of each row are the available actions: