[thelist] Backing up MySQL

Andy Budd andy at message.uk.com
Tue Mar 2 06:06:45 CST 2004


I'm wanting to automate the backing up of a MySQL database on my Mac.

I've written a shell script which basically does this.

mysqldump --user=$username --password=$password $dbname > 
$pathtobackup/$dbname.sql;

When I run it from the terminal, it all works fine. However If I make a 
cron job to run this script, a file gets output (so the cronjob is 
executing), but it's empty.

Any Ideas what the problem could be?


Andy Budd

http://www.message.uk.com/



More information about the thelist mailing list