I'm trying to backup a single MySql Database on my website using CRON but it's not working. Command is
/usr/bin/mysqldump -uUSERNAME -pPASSWORD --databases DATABASENAME | gzip > /home/MYSITE/forumbackup/backup.$(date +"%d_%m_%Y_%H_%M_%S").sql.gz
There is no error message in log files or the default email account. I know the location of mysqldump is correct as I checked with my hoster. I'm assuming gzip can be called as is.
any advice?