Prestashop: Install a regular backup of your database

Why save the database?

Accidents can happen in real life as in the online business . If we can not break the window of your ecommerce , it can get by against all sorts of things to your database. Whether the mere loss of data or an update that goes wrong, it is important to back up your database regularly.

So if you have a problem of accommodation, a problem appears in your database, or simply that you have deleted items from your catalog, you can simply restore a previous backup.

If you regularly back up its database can be tedious and dangerous (risk of forgetting € |), use a module to regularly back up its database can be a good thing!

Why Julien Breux of PSfrance has developed a very useful plugin to backup a database Prestashop . We will see its installation so that it backs up your database regularly.

First go to the article in the forum to download the module (you must be registered).

We will detail in the following lines how to install it and how to program automatic execution.

Installing the

Unpack the archive using a program like 7zip . Then move the module in the "modules" of your PrestaShop installation using your ftp client (like filezilla).
Visit the administration area of ​​your shop. Navigate to the Modules tab and click the "Install" button next to "Backup Database" in the "Tools".

Your module will be installed.

Module configuration

Back at the module level, and then click on the "Configure".

You should get a page like this:

The first step to take when you install this plugin is to make a backup by clicking "Make a backup now" (in the second part of the page).

The first part of the page, to restore an old copy of your database. So when you create backups, here you can select a previous backup and clicking "Restore" to get the date thereof.

The last part of the page allows you to choose the frequency of backups (you should choose daily then click Save).

Installing a Cron

The cron is a free program-specific systems ( http://fr.wikipedia.org/wiki/Cron ) to run a task regularly.

If your host allows it you can schedule a cron so it runs the backup automatically. You just have to set the autorun file, every day: cron.php that is in the file: modules / dbbackup / your PrestaShop store.

If you do not know how to install Cron, or your hosting does not offer it, then you can use the service http://www.webcron.org , which will allow you to automatically launch date and a regular file on your site.

Why register on this site: http://www.webcron.org/inscription.php , fill the fields. You should then receive an email confirmation (if this is not the case, check your spam box).

Once your account is activated, identify yourself on the right panel.

Go to the "My Tasks" using the top menu. Then click "New Task".

Complete the form as follows:

UrlUrl: http://votre-boutique.com/modules/dbbackup/cron.php (replacing your-boutique.com your address)

Time: 0

You can leave the other fields unchanged.

Finally click OK. You then have to click Enable in the table on the line for your site. Cron is close to your work.

Conclusion

Your shop is now protected against unexpected changes in your database.

To compensate for a failure of your host, it is important for you to recover your computer regularly back up your database (they are in "modules / dbbackup / dbcopies /").

WARNING: Restoring a backup is not trivial, you will lose all transactions since your eshop (your last order, your latest posts ...). That's why you should think twice before restoring the backup.

We recommend as a first step, make a backup of your current base before any restore operation, you will have an exit in case of misuse.

The author thinks the module add a function to send the mail back in a future release, so you do not download it from your accommodation.

Articles on this topic:

1. Tutorial: How to install the test database on Magento Feel free to sign up for RSS to not miss any article.Nous have seen in a previous post how to install Magento on your Windows computer, we will see now how to install the test database. To do this go ...
2. Manual: install the synchronization of products and inventory between two stores Prestashop via WebService Feel free to sign up for RSS to not miss any article.Cet article is the module manual available from our shop here. It will be constantly updated directly on the blog. The operation of the module is the ...