Page History

...

1. Open the phpMyAdmin tool, which should be available on your local server. Most of the time, it is located at http://127.0.0.1/phpmyadmin, or sometimes http://127.0.0.1/mysql.
2. If it is not already the case, create a new database especially for this project. Give it a distinctive name, like "prestashop_update" or even the database name for your production store, for instance.
   If you have already created a database for a previous local update test, just delete all of its tables.
3. Open de database, and click on the "Import" tab, located at the top of the screen.
4. Click on the "Browse" button and select the backup .sql file from your production store, which should be in the "prestashop-prod" folder.
   Check that the "Max." value displayed by phpMyAdmin is higher than the .sql file's size. If not, you will have to edit your local server's php.ini, particularly the upload_max_filesize value, the post_max_size value or even the memory_limit value as a last resort. This being done, restart the local Apache and MySQL servers in order to apply your modifications.

   Tip
   Instead of changing the server settings, you can also try compressing the .sql the file using a Zip tool, such as http://www.7-zip.org/. phpMyAdmin should accept .sql.zip files, and will take care of uncompressing the file before importing the data.

5. Click on the "Go" button to import the SQL file's content.

...