Why backup your database?

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

So if you have a hosting problem, a problem appears in your database, or simply that you delete 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!

For that of Julian Breux PSfrance has developed a plugin very useful to save a database Prestashop . We'll see its installation so that it backs up your database regularly.

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


Article on the backup database Prestashop

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

Module Installation

Unpack the archive using a program like 7zip . Then move the module into the folder "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 category "Tools".





Your module will be installed.

Configuration Module

Back at 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 on "Make a backup now" (in the second part of the page).

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



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

Installing a Cron

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

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

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

For that you enter on this site: http://www.webcron.org/inscription.php , fill the fields. You should then receive an email confirmation (if not, 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 on "New Task".

Fill out the form as follows:

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

Time: 0

You can leave the other fields unchanged.



Finally click on confirm. You then only click Enable in the table on the line on your site. Cron is close to your work.



Conclusion

Your store is now protected against the unexpected changes in 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 /").

CAUTION: Restoring a backup is not trivial, you will lose all transactions since your eShop (your last order, your latest articles ...). Therefore, you should think twice before you restore the backup.

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

The author thinks the module to add a feature to send the backup mail in a future version, so you do not download it from your accommodation.

    Articles on the same subject:

  1. Tutorial: How to install the test database on Magento Feel free to subscribe to the RSS feed to never miss any article.Nous have seen in a previous post how to install Magento on your Windows computer, we will now see how to install the test database. To do this go ...
  2. PrestaShop: Configure and install the PayPal module Feel free to subscribe to RSS feed to never miss any article.Même though today the majority of consumers use the net credit card, some customers are timid when to seizure of bank, especially ...
  3. Free module, to sell items from your shop Prestashop on your Facebook account Feel free to subscribe to RSS feed to never miss any article.Noà 's approach, the team Magavenue is proud to offer: a module to view the catalog for your PrestaShop store on your Facebook account. Your friends ...

3 comments why not let yours?

A cron will run a regular script.

Here the script is the system backup Database.

The Cron is launching regular backup script.
Depending on your accommodations, you can use 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 the module works by itself.
But what is alorqs Cron?
Thank
Nico

Nico May 6, 2009 at 14 h 35 min

It works in version 1.1?

Ehinarr January 18, 2009 à 23 h 54 min

Write comment