MySQL Command Line Backup

From Shell prompt Enter the following.
 $ mysqldump -u root -pmqr dbname |gzip -9 > /backup/koha/dbname-$(date +"%d-%m-%Y-%H:%M:%S").gz

This command will make mysql backup and compress it in the name format  dbname-06-08-2013-17:17:34.gz