mysqldump and crontab(linux)

Question

I want to make an automatic backup of my database, so i wrote like this

00 10   * * *   root     mysqldump -u root -ppasswordD billing "/home/backup/database_`date '+%m-%d-%Y'`.sql"

But it is not working, any ideas please?

Thanks and regards,

[Stack Overflow is not a Mind Reader or Crystal Ball](http://meta.stackexchange.com/a/128551/172496) — Brian Roach, Apr 25 '12 at 06:08
Can you tell me what information you need more ? I think it is clear enough to be understood! — alkhader, Apr 25 '12 at 06:11
How do you know it is "not working"? Does it produce error messages? If so, what are they? — geekosaur, Apr 25 '12 at 06:14
It is not creating a backup file. No it is not producing any error message. — alkhader, Apr 25 '12 at 06:15

score 1 · Accepted Answer · answered Apr 25 '12 at 07:07

1

00 10 * * * mysqldump -u root -ppasswordD billing "/home/backup/database_`date '+%m-%d-%Y'`.sql"

If it fails or produces any output then you will get a mail for root, read it with the command "mail" or read /var/log/cron.log ;)

answered Apr 25 '12 at 07:07

K1773R

1 Answers1