Download a database backup from your PrestaShop back office.
Go to the the "DB Backup" page, then follow the instructions on the page.
This page is available from:
- PrestaShop 1.4: under the "Tools" tab, in the "DB Backup" sub-tab.
- PrestaShop 1.5 and later: under the "Advanced parameters", in the "DB Backup" page.
This process will take between 1 and 20 minutes depending on the size of your database, after you will see a link appear on the page, titled "Download the Backup file (size)". Click it, and make sure this backup is functional, recent, and especially that it contains of all contains all the data of your website. Open the zip file and make sure that there are absolutely NO ERRORS in the
.sqlfile it contains before proceeding to the next step.