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

Question

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 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.

Answer 1

1

Two questions:

Is your backup script run at all by cron?
1. If yes, where mysqldump located? usually cron has very limited PATH, so if mysqldump located say in /usr/local/bin it's unlikely be found in the PATH by cron. Then either specify full path or set in the script PATH environment variable

link

answered 29 Feb '12, 16:37

Valery Reznic
21●2
accept rate: 0%

Answer 2

0	Did you find any emails/logs from the cron job showing what error messages/output was made? If so - can you add them to your question. link answered 01 Mar '12, 04:47 dannystaple 1 accept rate: 0%

Answer 3

0	Hi, Change the cron timing to 05 00 * * * /home/Mysqluser/daily_dumps/bin/backup_database.sh. Hope it works. --Regards, Sumit. link answered 21 Apr '12, 00:51 August 11●1 accept rate: 0%

Answer 4

0	Maybe user/group permissions on your script. link answered 15 Jun '12, 07:40 fatmac 41●5 accept rate: 0%

Please note that LinuxExchange will be shutting down on December 31st, 2016. Visit this thread for additional information and to provide feedback.

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

Follow this question

Related questions