Uploading a back up?

[swifftyb]

How do i upload a backup that i have made of prestashop? Also what will this restore? Does the back up hold my images and products? Thanks!

[rocky]

Do you mean the backup generated from the Tools > DB Backup tab? That is a backup of your database only. It does not include any of the images of your site. You need to back up the img directory separately to your database backup.

You must use phpMyAdmin to restore a database backup. From there, you can delete all the existing (backed up!) Prestashop tables in your database and then run the SQL query you downloaded from the Tools > DB Backup tab to restore the previous Prestashop tables. Note that you will lose all the customers, orders and statistics made since the backup, so this isn't a good idea on a live site, only on a test site.

If it is only the categories and products you want to restore, it may be better to create a copy of the backup file and then delete all the SQL queries except for the category and product tables and restore those only. Be aware that the orders contain product IDs, so it they don't match, then the customer's orders won't display properly.

As you can see, while restoring backups on a test site is very easy, since you don't have live data to worry about, restoring backups on a live site can be very messy. It may be easier to just fix whatever problem has gone wrong than to risk creating more problems by restoring a backup on a live site.