Automatizing the backup of my databases and files with cron

Posted by Patrick on Server Fault See other posts from Server Fault or by Patrick
Published on 2011-01-03T11:48:38Z Indexed on 2011/01/03 11:55 UTC
Read the original article Hit count: 321

Filed under:

crontab

hi,

I want to automatize the backup of my databases and files with cron. Should I add the following lines to crontab ?

mysqldump -u root -pPASSWORD database_name | gzip > /home/backup/database_`date +\%m-\%d-\%Y`.sql.gz

svn commit -m "Committing the working copy containing the database dump"

1) First of all, is this a good approach ? 2) It is not clear how to specify the repository and the working copy with svn" 3) How can I run svn only when the mysqldump is done and not before ? Avoiding conflicts

Any other tip ? thanks

Automatizing the backup of my databases and files with cron

Posted by Patrick on Ask Ubuntu See other posts from Ask Ubuntu or by Patrick
Published on 2011-01-03T11:48:01Z Indexed on 2011/01/03 11:59 UTC
Read the original article Hit count: 321

Filed under:

cron-jobs

|

crontab

|

cron

|

svn

hi,

I want to automatize the backup of my databases and files with cron. Should I add the following lines to crontab ?

mysqldump -u root -pPASSWORD database_name | gzip > /home/backup/database_`date +\%m-\%d-\%Y`.sql.gz

svn commit -m "Committing the working copy containing the database dump"

1) First of all, is this a good approach?
2) It is not clear how to specify the repository and the working copy with svn.
3) How can I run svn only when the mysqldump is done and not before ? Avoiding conflicts

Any other tip ? thanks

Developer IT