Help With Cron Auto Backup

[plstim]

Hi Alll,

First post here. What I want to do is schedule cron on a shared server to once a day copy my mysql database and sugarcrm folder to backup folders. I have been so far unsuccessful so perhaps you could help. Here is what I have so far:

01 00 * * * mysqldump --opt -u[user] -[password] [database] > /backup/db/sugarce_backup_current.sql;mv /backup/db/sugarce_backup_current.sql /backup/db/$(date +%m%d%Ysugarce_backup.sql);gzip -f /backup/db/$(date +%m%d%Ysugarce_backup.sql);

45 00 * * * cp -rf /public_html/sugarcrm /backup/apps/sugarce;tar -cf /backup/apps/sugarce.tar /backup/apps/sugarce;rm -rf /backup/apps/sugarce;gzip -f /backup/apps/sugarce.tar; mv /backup/apps/sugarce.tar.gz /backup/apps/$(date +%m%d%Ysugarce_backup.tar.gz);

here is the error I am getting emailed to me from both cron jobs:

/bin/sh: -c: line 0: unexpected EOF while looking for matching `)'
/bin/sh: -c: line 1: syntax error: unexpected end of file

Now I have them set up as 2 separate cron jobs. Is this the problem? any help here? I am very new to this. I found this code somewhere on the forums but I didn't know if I should resurrect an ancient thread. Sorry if I should have.

Thanks in advance

[plstim]

Hi All,

I found this solution the solution below that mostly works. The problem was with the timestamp that was being added. I have one more issue though. I can only get this to work when I send the output to the root directory so like /home/nameofserver.

If I use /home/nameofserver/backup I get an error saying "no such file or directory". I have added the directory and even changed the permissions to 777 just to see if that works and it still didn't. Any ideas?



mysqldump -u[user] -p[password] db > /home/name/example.sql;mv /home/name/example.sql /home/name/`date +\%Y-\%m-\%d-\%H-\%M-\%S`example.sql;gzip -f /home/name/`date +\%Y-\%m-\%d-\%H-\%M-\%S`example.sql

cp -rf /home/name/public_html/sugarcrm /home/name/sugar;tar -cf /home/name/sugar.tar /home/name/sugar;rm -rf /home/name/sugar;gzip -f /home/name/sugar.tar; mv /home/name/sugar.tar.gz /home/name/`date +\%Y-\%m-\%d-\%H-\%M-\%S`sugar_backup.tar.gz