MySQL Auto Backup

This is a one line backup command. You will find number of scripts on the Internet

/usr/bin/mysqldump -u root -p password --all-databases >/data/mysqlbkp/backupfile_`date +"%m-%d-%Y"`.sql