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: 285

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

© Ask Ubuntu or respective owner

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: 285

Filed under:

svn

|

cron

|

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

© Server Fault or respective owner

Related posts about cron-jobs

Group readable cron jobs a security risk?

as seen on Server Fault - Search for 'Server Fault'
Hi, I was just wondering, is using a cron job that is group readable a security risk? In this case, the script is chmod 755, and the group is basically a group of the sysadmins on the machine. The permissions seem to be fine, but I'm just wondering whether it's a bad idea to keep this script in a… >>> More
PHP/Cronjob: What is my Cronjobs problem?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello there, I have no idea whats going on. But I have a script that looks like this. Cron job refuses to run it: include_once 'class_lib/mime_mail/mimeDecode.php'; include_once 'class_lib/Mail/IMAPv2.php'; include_once 'inc-functions.php'; include_once "$_SERVER[DOCUMENT_ROOT]/class_lib/DbFuctioneer… >>> More
How many cron jobs are too many?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a couple of cron jobs for basic maintenance which aren't very resource-intensive. I also have custom task scheduling (which is just calling a .php file and passing information via GET, ie: cronjob.php?param1=param ...). These can add up pretty quickly. These just call system commands and… >>> More
Php run cronjobs

as seen on Stack Overflow - Search for 'Stack Overflow'
How can i run an cron job from php, and the cron to start in that moment? I have a sitemap script, and i want to turn to a sitemap link, without waiting for him to do his job, to send information to call my job horn Sitemap. Sorry my English >>> More
CRON jobs in php deployed in windows platform

as seen on Stack Overflow - Search for 'Stack Overflow'
How to run a scheduled job scripted in php using windows >>> More

Related posts about crontab

/etc/crontab or any user crontab is not being executed

as seen on Server Fault - Search for 'Server Fault'
My server is CentOS 5. When I edit /etc/crontab or edit any user(including root) crontab via "crontab -e" command, it just adds "(system) RELOAD (/etc/crontab)" or "(admin) RELOAD (cron/admin)" in the log. No CMD in the /var/log/cron. Sample entry in /var/log/cron: Aug 10 10:21:33 localhost crontab[31688]:… >>> More
How to execute shell script via crontab?

as seen on Super User - Search for 'Super User'
notify.sh script file looks like: notify-send "hi welcome" my crontab notification for 2 pm: * 14 * * * home/hacks/notify.sh This is very basic queston only.But it wont working. should i configure anything? >>> More
Crontab no error but doesn't execute script

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to execute a shell script from cron on Freebsd. To test wether crontab is working at all, i wrote the line * * * * * echo "Hello" /home/myuser/logile and it work fine. But when trying to execute any script it doesn't do anything, not even an error. (In the script i tried to run is… >>> More
Crontab: cut line to many lines?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hard-to-read-line @daily export sunshine="~/logs/Sunshine-`date '+\%F'`" && export sunshineUrl="http://www.sunshine.net/main/search_results.asp?currency_id=1&min_price=&max_price=50000&country_id=241&region_id=&Submit=Search" && mkdir -p $sunshine && cd… >>> More
Crontab + rails3 + bundler

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm running a crontab that executes a rake task. I'm getting the following error (with MAILTO from crontab): rake aborted! no such file to load -- bundler /Users/Mendel/Sites/misnooit/Rakefile:4 (See full trace by running task with --trace) I'm using rvm with: ruby: ruby 1.9.1p378 rails: Rails… >>> More