Crontab presta database backup

[Drew]

Hello guys and girls

I am trying to set up cron tab to back up my data base every day or ever week, but I really don't have a clue what I'm doing, would any one be able to provide a little step by step of how to do it, I'm currently using site ground as my host

Also using crontab can it be told to save my backups to my computer or will it auto save to the webserver? If so can it be told to save to two different webservers?

[PointandStare]

Depending on your set up you could use something like this which will gzip a copy of your database and email it to the address you specify:
CAPITALS are to be completed with your details -
/usr/bin/mysqldump -ce --user=USERNAME --password=PASSWORD DATABASENAME | gzip | uuencode NAMETOBESAVEDAS.sql.gz | mail -s "EMAIL SUBJECT" [email protected]

Then set it to:
Which means send it to me every Sunday
0 0 * * 6

BUT before you do anything speak to your host.

[Drew]

thanks very much, sadly site ground has some of the worst customer care i have ever incountered, so ill play around and see what happends thank you very much

[Bejo]

i tried but only got empty text. did it work with ps 1.5 ?

[vekia]

I've got application for automatic mysql backup and putting it into google drive I will write module for presta which can do it directly from shop

[Sickboards]

Hi Vekia, 

 

Did you ever create this module, I could not find it on your site.

[scottstephen]

I use a simple bash script to backup the DB.

Note, that it doesn't matter which version of Prestashop you are using, this is related strictly to MySQL.

 

Put the following into a .sh file and make it executable.

#==============

#!/bin/bash

 

#date du jour

DATE=`date +%Y%m%d_%H%M%S`

 

mysqldump --add-drop-table -u db_username -pdb_password database | gzip > /home/backup/$DATE"_filename".sql.gz

#==============

 

This will create a full backup of the specified DB and gzip it.

Of course you will need to specify a correct path for the destination file.

 

Then you can add it to crontab with the following.

 

crontab -e

00 00 * * * /usr/local/sbin/backup_script.sh

 

This will run your backup script daily at midnight.

 

Hope that helps.

[vekia]

now after some time i also use bash script to mysql dump, in addition i added feature to upload files to dropbox:

solution here: http://www.webupd8.org/2013/01/dropbox-uploader-bash-script-useful-for.html