Adding date to crontab mysqldump

After mangling some crontabs commands, I finally got the date into mysql exports.

mysqldump -u database-user -h localhost -pdatabase-password database | gzip -9 > /path/to/backup/directory/database-data`date +%m%d%y`.sql.gz

This command will dump the database, gzip it then add the date to the exported file. Basically if you had problems adding a date to the export file you most likely forgot to add a '\' before the %m, %d, or the %y.

edit: well it looks like my blog is actually removing the \ before the %m%d%y in the command. It should look like this minus the spaces...

\ %m \ %d \ %y