I'm trying to take backup every day and want to name the file by date, but it doesn't work:
mysqldump DATABASE -u USER -pPASSWORD > "/home/backups/$(date +%d-%m-%Y)_db_backup.sql"