cron syntax error

hi,

i have this line in the cron file:

0 0 * * * /usr/local/mysql/bin/mysqldump -uXXX -pXXX -A | gzip > /var/www/html/backup.gz


I was trying to backup mysql db using crontab but it keeps giving me error with the '|' sign. Anyone knows how to overcome that?

thanks.

 

Hey Des,

If you're still having the problem it may because you dont have the route to Gzip path specified or whatever version of cron you are using doesn't like the pipe, in which case either put the whole command in "", or just have it run a shell script which does the command

 

or if u use cpanel goto krakjoe.info and download the cpanel backup tool for free...