mysqldump cron job won't run
Hello, I am new to using cron jobs, and I have need to create a dump file of all the mysql databases daily. I set up a cron job, but it won't run. I installed it as follows:
15 10 * * * /usr/bin/mysqldump --all-databases -u root -p'*password*' | gzip -c > /home/db_backup/database_`date +%a`.sql.gz
saved and closed the file
restarted cron daemon
The job will not kick off. I run the command manually and it works just fine.
Do I have to do this as a script file?