Cron + MySQL Backup

[resilientclan]

Hey x10!

So I have this cron job, with this command:

mysqldump -user=rgclan_db1 --password=MYPASSWORD --all-databases | gzip > /home/rgclan/backups/sql_`date %m-%d-%Y'`.sql.gz

with intent to just dump and compress my MySQL databases.

The problem is all I get is a 20 byte empty .gz file.

Anybody have some insight as to what could cause this? Maybe someone can give me a working line?

---------- Post added at 11:33 AM ---------- Previous post was at 11:30 AM ----------

Forum isn't letting me edit that last post...
this is the actual line:

mysqldump -user=rgclan_db1 --password=MYPASSWORD --all-databases | gzip > /home/rgclan/backups/sql_`date +%m-%d-%Y'`.sql.gz

 

[GtoXic]

OK, I took a final look when you left IRC and I have the code that works for me which should also work on the x10 servers.

mysqldump -uUSER --password=PASSWORD --all-databases | gzip > path/to/directory/sql_`date +%m-%d-%Y`.sql.gz