Linux Shell implements a daily scheduled backup of the MySQL database _linux shell

Daily backup MySQL database tasks, delete the specified number of days before the data, keep the date of the specified day;

Demand:

1, backup MySQL data 4 points per day;

2, to save space, delete more than 3 months of all backup data;

3, delete more than 7 days of backup data, keep 3 months of 10th number 20th number of backup data;

#创建shell文件
vim backup_mysql.sh
 
mysqldump-uroot-p123456--all-databases >/data/dbdata/mysqlbak/' Date +%Y %m%d '. SQL
find/data/dbdata/mysqlbak/-mtime +7-name ' *[1-9].sql '-exec rm-rf {} \;
find/data/dbdata/mysqlbak/-mtime +92-name ' *.sql '-exec rm-rf {} \;
 
#创建定时任务
crontab–e
0 4 * * */data/dbdata/backup_mysql.sh

The above is the entire content of this article, I hope that you can be proficient in the shell script to help.