backup

How create a Prestashop database backup

Background

Sometimes when making changes in Prestashop I feel that we loose control. You unhook one module and the whole site explodes (or maybe implodes) and it might be hard to understand what happened.

In these scenarios as always the recommendation is to backup the site and the database. However if you are on a standard ftp connection with your hosting provider, downloading the whole shop might take a very long time.

If you are just testing new modules or trying to remove some Prestashop modules to make your site faster, then it might be enough just to make a backup of the database. This way if things go bad, you can just restore this backup and you are back where you started with a working shop.

In this example we will show how to make a backup using Plesk. The good thing with this approach is that it is generic so it applies for any mySQL database, Prestashop, WordPress etc and since we normally do a lot of things like copying files and editing configs through Plesk rather than through ftp it is starting to feel like a familiar environment.

Getting started

Start by logging into Plesk with your username and password provided by your hosting company. You will see a screen of the

Finding the database to backup

If you click on the tab called “Websites and Domains” and then on “Databases” you will get into the Plesk database page. plesk-databases
Find the database that is attached to your Prestashop installation.

Click on the webadmin button

prestashop database for backup

Database for backup


and you will get into the phpMyAdmin tool.
phpMyAdmin prestashop
Where you will see a huge table of database info. You can just ignore all that.

Exporting the database

Now just click the Export button:
myPhpAdmin-export-database
and click Continue.

Now a download of your database will start automatically and you are done.

As long as you only modify things from the Prestashop admin, if anything goes wrong it can usually be restored by simply Importing this Prestashop database again. How to Import a Prestashop database backup is explained in this blogpost.

Leave a Reply