I'm using the following in crontab:36 22 * * * root mysqldump -u CENSORED -p CENSORED server | gzip > /home/samp/samp03/scriptfiles/sql-backup/server_backup_`date + \%d-\%m-\%y`.sqlbut I'm getting the following error in mail (I want to keep the separators [-]):date: extra operand `%d-%m-%y'
Using MYSQLDUMP to backup automatically a DB server
linux;backup;mysql