Results 1 to 2 of 2
Thread: mysqldump cron job won't run
|
Enjoy an ad free experience by logging in. Not a member yet? Register.
|
|
-
01-18-2012 #1
- Join Date
- Jan 2012
- Location
- Ohio
- Posts
- 175
mysqldump cron job won't run
crontab -e
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?
Any ideas?
-
01-18-2012 #2
- Join Date
- Jan 2012
- Location
- Ohio
- Posts
- 175
fixed
Nevermind. I fixed it. For some reason, cron was stopping in the file name. I changed the name and it worked fine. I will just have to set up different jobs for different days of the week as I want a weeks worth of backups.