Why save its 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 € |), using 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 forum article to download the module (you must be registered).


Article on backing up the database Prestashop

We will detail in the following lines how to install it and how to schedule it to run automatically.

Installing the module

Unpack the archive using a program like 7zip . Then move the module in the "modules" of your installation Prestashop 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" category.





Your module will be installed.

Module configuration

Return to the module level, then click the link "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 once you have created 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 (we recommend choosing daily and then click Save).

Installing a Cron

Cron is a program specific to free 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 and regular date a file on your site.

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

Once your account is activated, login 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 confirm. You do then simply click Activate in the table on the line on your site. Cron is close to your work.



Conclusion

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

To overcome a problem with 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 lose all transactions since your eshop (your last order, your latest posts ...). This is why you should think twice before restoring this backup.

We advise you in first, 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 to add a feature to send the backup mail in a future release, so you do not download it from your accommodation.

    Items on the same subject:

  1. Tutorial: How to install the test database on Magento Feel free to sign up for RSS feeds do 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 article.Cet not miss any article is the module manual available from our store here. It will be constantly updated directly on the blog. The operation of the module is ...

6 comments why not leave yours?

We will not comment for support by a technical problem with one of our modules. Thank you contact us directly with our contact form !

Hi Eric,
Prestashop core integrates this feature in Tools> Backup DB

Magavenue February 29, 2012 at 11 am 49 min

the plugin to save his bdd is it still available somewhere because the link does not work

eric February 23, 2012 to 22 h 17 min

Hello,
Can someone send me this module by email or a link? the download page no longer exists ...
I can not find another free alternative ...
thank you

Nicolas October 15, 2011 at 9 am 53 min

Cron can start a regular script.

Here is the script the backup system Database.

Cron is launching the regular backup script.
Next your accommodation, you can use it to set the Cron.

Magavenue 6 May 2009 to 22 h 09 min

Hello,
I do not understand,
Cron is what it takes to run the module or module works by itself.
But what is alorqs Cron?
Merçi
Nico

Nico May 6, 2009 at 14 h 35 min

Write a comment