I want to automate 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.gzsvn commit -m "Committing the working copy containing the database dump"
First of all, is this a good approach?
It is not clear how to specify the repository and the working copy with svn?
How can I run svn only when the mysqldump is done and not before ? Avoiding conflicts
1) If you insist on storing backups in subversion, then there is nothing wrong with this approach. It is strange, though.
2) You should keep a checkout around, place the dump into the working directory, and run
svn update and
svn add as appropriate before committing.
3) If you run the commands as shown from a shell script, there should be no overlap.