Prestashop: Install a regular backup of your database

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 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 housing problem, a problem appears in your database, or simply that you have deleted items from your catalog, you can simply restore a previous backup.

If, regularly back up your 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 Julien Breux of PSfrance has developed a very useful plugin to save a database Prestashop. We will see its installation so that it backup your database regularly.

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

We will explain 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).
Go to the admin section of your store. Navigate to the Modules tab and click the Install button in front of "Backup Database" in the "Tools".

Your module will be installed.

Configuration Module

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

You should get a page like this:

The 1st step to perform when you install this plugin is to make a backup by clicking on "Make a backup now" (in the 2nd half of 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 find yourself at the date thereof.

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

Installing a Cron

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

If your provider allows it you can schedule a cron so it runs the backup automatically. You only have to set the autorun file, every day: cron.php located in the folder modules / dbbackup / Prestashop your store.

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

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

Once your account is activated, you identify the right panel.

Visit 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 other fields unchanged.

Finally click OK. You then have to click on Activate in the table on the line on your site. Your Cron is ready to operate.

Conclusion

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

To remedy 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 /").

CAUTION: Restoring a backup is not trivial, you lose all transactions on your eShop From (your last order, your latest articles ...). Therefore 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'll have an exit in case of false manipulation.

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

Articles on the same subject:

1. Tutorial: How to install the test database on Magento Feel free to subscribe to RSS feed to avoid missing any article.Nous've 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 Feel free to subscribe to RSS feed to avoid missing any article.Même though today the majority of consumers on the net using the credit card, some customers are timid when to data entry bank, especially ...
3. Free module, to sell items from your shop Prestashop on your Facebook account Feel free to subscribe to RSS feed to avoid missing any article.Noà 's approach; Magavenue team is proud to offer: a module to view the catalog of your shop Prestashop on your Facebook account. Your friends ...