3
votes
1answer
502 views

Shell script of mysqldump works fine when run manually, but does not run in the cron job?

I have a shell script to get a MySQL database dump. This script works fine when run manually #!/bin/sh fqn=/home/Mysqluser/daily_dumps/bookstore_`date +%Y%m%d_%H%M%S`.sql.gz mysqldump -u root -h ...
1
vote
4answers
2k views

mysqldump cron not dumping

I am attempting to setup a cron to use mysqldump once a day. There is no output and I cannot see any database usage while watching top. The crontab is: mysqldump [database] -u[user] -p'[password]' ...
1
vote
1answer
232 views

Having trouble running a cron job in Unix which generates a dynamic filename for an output data dump

I am trying to schedule a MySQL database dump by using cron but I get an error for some code that I know works when I call directly in Shell. Here is the code that works perfectly well in Shell: ...