[thelist] Backing up MySQL

[Alan McCoy]

A good friend of mine wrote this one.

http://freshmeat.net/projects/mysqlbackup/

Not sure if it works on a Mac, but it is a real life/time/sanity saver on my
Linux server.

Alan

=> 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?