How to Backup MySQL Database automatically (for Linux users)
mysqldump -u root -pPASSWORD --all-databases | gzip > /mnt/disk2/database_`data ' %m-%d-%Y'`.sql.gz
# mysqldump ---user [user name] ---password=[password]
# [database name] > [dump file]
mysqldump -u root -pPASSWORD --all-databases | gzip > /mnt/disk2/database_`data ' %m-%d-%Y'`.sql.gz
# mysqldump ---user [user name] ---password=[password]
# [database name] > [dump file]
