http://linuxexchange.org/tags/mysqldump/?type=rssquestions tagged <span class="tag">mysqldump</span>enWed, 29 Feb 2012 02:04:02 -0500http://linuxexchange.org/questions/2792/shell-script-of-mysqldump-works-fine-when-run-manually-but-does-not-run-in-the-cron-job<p>hi. i have a shell script to get a mysql db dump. this script works fine when run manually</p> <pre><code>#!/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 &gt; $fqn </code></pre> <p>but when i include this script to be run in cron job, it doesnt make the backup</p> <p>this is what i included in the cron job</p> <pre><code>00 00 * * * /home/Mysqluser/daily_dumps/bin/backup_database.sh </code></pre> <p>please explain what am i missing here.</p>saleemmsmsWed, 29 Feb 2012 02:04:02 -0500http://linuxexchange.org/questions/2792/shell-script-of-mysqldump-works-fine-when-run-manually-but-does-not-run-in-the-cron-jobmysqldumpcrontabhttp://linuxexchange.org/questions/139/mysqldump-to-crontab<p>I try to set mysqldump to crontab but for some reason it's not working. maybe it's too long? I tried to put it in /etc/crontab and crontab -e mysqldump --default-character-set=utf8... how can i fix that?</p>S2eveTue, 27 Apr 2010 17:53:01 -0400http://linuxexchange.org/questions/139/mysqldump-to-crontabmysqldumpcrontab