NYCPHP Meetup

[nycphp-talk] [ot] mysqldump cron problem

Hans Kaspersetz lamolist at cyberxdesigns.com
Sun Feb 19 07:41:05 EST 2006


I created a bash script that is supposed to dump one of my databases.  
When I run the bash script from the cli it dumps no problem.  When I 
call the script from cron, I get an empty file in the destination 
directory.  Anyone have any ideas?

FreeBSD 5.3
MySQL 4.1

--------------------------------
#!/usr/local/bin/bash
path="/usr/local/backups/"

date=`date +"%y%m%d-%H%M%S"`
filename=$path$date"-oncellrx.sql"

mysqldump --opt -Q -uUSER -pPASS DATABASE > $filename
------------------------------------

I am calling the script as myself from cron.  Bash is set as my shell in 
passwd.  Seems sorta mysterious to me.

Hans



More information about the talk mailing list