How Linux automatically backs up MySQL database every day font: [Increase decrease] Type: Reproduced under Linux for security sometimes need to automatically back up the MySQL database, the following is the specific implementation steps. /usr/bin for MySQL installation directory
To create a backup folder:
mkdir Mysql_data_bak
To build the script file:
Touch autobackupmysql.sh
Open File
VI autobackupmysql.sh
Add the following to the script:
Filename= ' Date +%y%m%d '
/usr/bin/mysqldump-opt mysql-u Root-proot|gzip >/mysql_data_bak/name$filename.gz
Notice here.
In general:
**********************************************************
Open the Auto-execute file
Vi/etc/crontab
Add the following to the ETC and let it perform the task automatically.
* * * * * root/mysql_data_bak/autobackupmysql
**********************************************************
Redhat Method:
Redhat's crontab takes 4 directories per time (/etc/cron.hourly: hourly;/etc/cron.daily: every
/etc/cron.weekly: Weekly;/etc/cron.monthly: monthly) The way the script comes out.
Just copy the script you just edited to the appropriate directory in the Redhat.
Cp/mysql_data_bak/autobackupmysql etc/cron.daily
Restart etc
/etc/rc.d/init.d/crond restart
How Linux automatically backs up MySQL database on a daily basis
