cron job error

asked Aug 1, 2012 in General by MirrorXYZ (1,400 points)
Hi there

I have a problem and would appreciate any help
After my cron job runs, I get the below error sent to my email

 /bin/sh: -c: line 0: syntax error near unexpected token `('
 /bin/sh: -c: line 0: `mysqldump --opt -Q -u USERNAME  --password=password(word) secondpart dbname | gzip > /root/backupfolder/saturday.gz'

how can I fix this?
Thanks in advanced

1 Answer

0 like 0 dislike
answered Aug 1, 2012 by WebGuru (9,280 points)
You have to create another MySQL user with a normal password . The problem is caused by the ‘()’ in your password.