How to automatically back up mysql databases on a daily basis in Linux

/Usr/bin: mysql installation directory
Create a backup Folder:
Mkdir mysql_data_bak
Create a script file:
Touch autobackupmysql. sh
Open a file
Vi autobackupmysql. sh
Add the following content to the script:
Filename = 'date + % Y % m % d'
/Usr/bin/mysqldump-opt mysql-u root-proot | gzip>/mysql_data_bak/name1_filename.gz
Note that
General:
**************************************** ******************
Open the automatic execution File
Vi/etc/crontab
Add the following content to etc to automatically execute the task.
01 15 *** root/mysql_data_bak/autobackupmysql
**************************************** ******************
Redhat method:
The crontab of Redhat calls four directories by time (/etc/cron. hourly: hourly;/etc/cron. daily: Every
Days;/etc/cron. weekly: weekly;/etc/cron. monthly: monthly.
In Redhat, you only need to copy the edited script to the corresponding directory.
Cp/mysql_data_bak/autobackupmysql etc/cron. daily
Restart etc
/Etc/rc. d/init. d/crond restart