Crontab problem

shafey · 10-29-2006, 11:34 PM

What's problem in this syntax of crontab
0 5 * * 1,3,6 mysqldump dbname > /home/backup/manualy/mysql/filename-`date +%d-%m-%y`.sql

I need to run mysql backup day by day at 05:00 AM, I tried the command and it's working properly but cron not running .. what's wrong ?

Freemor · 10-30-2006, 01:06 AM

The syntax look fine to me .. but I had similar problems setting up a cron job to do some PVR work for me.. in my case the solution was to move the more complex command into a bash script and then use cron to call the script. I never figured out why it didn't work straight from cron but suspected it had to do with the use of the `date +%m%d` I use in the command.

it all works fine now.

Hope this helps
Freemor

shafey · 10-30-2006, 03:20 AM

Thanks

hi ali

i have got the Right syntax

0 5 * * 1,3,6 mysqldump dbname > /home/backup/manualy/mysql/$(date +%d-%m-%y)

Quigi · 10-30-2006, 11:36 AM

If you're inclined to read the friendly manual

, it tells you:

Quote:

Originally Posted by man 5 crontab

Percent-signs (%) in the command, unless escaped with backslash (\), will be changed into newline characters, and all data after the first % will be sent to the command as standard input.

E.g., here's a line from my crontab

Code:

33 3 * * * /home/monet/finance/script/consolidate 5 \%Y-\%m-\%d '??-??-??'

(And, as you have guessed, date uses that format.)

linux2man · 10-31-2006, 12:09 AM

Many Thanks
Problem fixed