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 localhost -pmysql#passwd 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
What am I missing here?