Auto Database Backup with "CRON" module

[Captain FLAM 71]

Not really a module, but ... th title says all

 

The CRON module is free and already available in PrestaShop

 

Final Solution for PS 1.6 (not yet tested with 1.7) :

 

Put this file : cron_database_backup.php

 

-> in your admin folder, and then in your "CRON" module config, put one link like this :

 

h t t p :/ / w w w . your_site . com / your_admin_folder / cron_database_backup.php?secure_key=your_key

 

Tip : to find your key look at the other cron tasks

 

Thanks to @NemoPS in this subject, to have putting me on the right way

Edited June 8, 2017 by Captain FLAM (see edit history)

[nicolabisio 0]

Hi Capitan FLAM,

I've tested your script, but I found a sort of limit about file or query.

Seams to not be the best choice when you have large DB.

Have you find any trouble about it?

Thanks
Nicola

[Captain FLAM 71]

Probably because of the time limit of php scripts ...

Sometimes, you can change your php.ini, but main hosters don't permit even to customize it.

so you can try to add at the beginning " cron_database_backup.php " just after the <? php , this :

ini_set( 'max_execution_time', '600' );

it will change the max execution to 10 minutes (10 * 60 sec)

Let me know if it works

Edited January 9, 2018 by Captain FLAM (see edit history)

[Hacktor 1]

Hi, is the backup-script already modified and compatible with Prestashop 1.7.2.4 ????

[Captain FLAM 71]

I have not tried (because I don't use the 1.7 version), but ... it maybe works as it uses the "classes/PrestaShopBackup.php" file provided by Presta team

You have to try it by yourself 

[razvy 3]

Hi,

Thank you for this solution, I was looking for something like this.

But please tell me how to find the secure key, I don't have any other cron jobs set yet.

Thanks!

Edited March 4, 2018 by razvy (see edit history)

[tantan199 49]

On 2018/3/5 at 1:34 AM, razvy said:

Hi,

Thank you for this solution, I was looking for something like this.

But please tell me how to find the secure key, I don't have any other cron jobs set yet.

Thanks!

The secure key = md5(_COOKIE_KEY_+Your Shop name).

[nuevoenesto 6]

Hi

I tray to test this solution, but not working in my site. I have the admin folder like protected folder. Can be this a problem?

Thanks

Enrique

 

[annx10 1]

Hi.

I have put "cron_database_backup.php" file in the administration folder and I have configurated cron task.

In the task list it is with last execution yesterday, perfect, but where backups are saved?

I have searched in folder administration/backups, but there isn't nothing.

I have PrestaShop 1.6.1.20

Regards.

[nuevoenesto 6]

Hi

The Backup file is in the administrator folder / Backup

Kind Regards

Enrique

[annx10 1]

23 hours ago, nuevoenesto said:

Hi

The Backup file is in the administrator folder / Backup

Kind Regards

Enrique

 

Hi, Enrique.

Have you read my post?

Althought Cron task is like executed, when I go to folder administration/backups, there isn't backup files. Only when I execute manual backup in Advanced Parameters backup file is saved in that folder.

Regards.

[schickard 0]

On 3/4/2018 at 6:34 PM, razvy said:

Hi,

Thank you for this solution, I was looking for something like this.

But please tell me how to find the secure key, I don't have any other cron jobs set yet.

Thanks!

Hi,

you can display the expected key with this:

Open the script, after "$secureKey = md5(....." add in a new line this:

print "$secureKey";

Save and open the site: w w w . your_site . com / your_admin_folder / cron_database_backup.php?secure_key=FALSE

The key will printed and nothing other will do. Copy the key and dont forget to remove the inserted line again.

 

Christian

 

[burakpresta3 2]

Any idea which function calls the backup under 1.7.6.4

thanks. 

 

@Captain FLAM

Edited April 24, 2020 by burakpresta3 (see edit history)

[Captain FLAM 71]

Le 09/01/2018 à 11:23 AM, Captain FLAM a dit :

I have not tried (because I don't use the 1.7 version), but ... it maybe works as it uses the "classes/PrestaShopBackup.php" file provided by Presta team

You have to try it by yourself 

Let see if some coder use the 1.7 version and can help you

[burakpresta3 2]

@Captain FLAM

it is super complicated, i checked little bit, it is hard to solve some one else. i guess it is not an simple function, but someone can trigger the form which sends backup demands, we could use the old backupper. 

[Brooke79 0]

Hi, we have bought the module that performs database and file backups. The cron commands as explained in the guide didn't work our until we changed it to "get" command instead.

But now the cron manages to perform each nigh the database backup (which is still quite small in size) but no file backup is performed . We are hosted at 1and1 and if we launch manually the backup it works (or I should say it displays an error but a file is generated paymydoctor) but the automatic task doesn't give anything. Some clue ?

The module bought is the Presta-Changeo module.

Edited May 5, 2020 by Brooke79
word missing (see edit history)

[Captain FLAM 71]

Il y a 20 heures, Brooke79 a dit :

Hi, we have bought the module that performs database and file backups. The cron commands as explained in the guide didn't work our until we changed it to "get" command instead.
... ...
The module bought is the Presta-Changeo module.

You have to post in the Presta-Changeo module, NOT THERE !

or email to the dev ...

Thanks.

[MathiasReker 20]

Hello. I have made a free module that backup database by a cronjob.

My module works on both 1.6 and 1.7.

Link til module:

 

[Captain FLAM 71]

Very strange : your link is not there, so I put it again :

https://www.prestashop.com/forums/topic/984993-free-module-advanced-security-module/

(EDIT : you have to insert as a link instead)

Edited May 13, 2020 by Captain FLAM (see edit history)

[Jack 1 0]

I would also look into AWS Backup that was recently released a couple of months ago. You can define when to backup, how long to keep them and can backup other services as well.