[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
Automatic Email Organization without missing anything!