shell script of mysqldump works fine when run manually, but does not run in the cron job ?
hi.
i have a shell script to get a mysql db 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 localhost -pmysql#passwd global_portal_baseline_ise bookstore | gzip > $fqn
but when i include this script to be run in cron job, it doesnt make the backup
this is what i included in the cron job
00 00 * * * /home/Mysqluser/daily_dumps/bin/backup_database.sh
please explain what am i missing here.