[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