Backup MySQL database tasks regularly every day

1, backup MySQL data at 0 points per day;

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

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

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

Note: Backing up data
Mysqldump--extended-insert=false/true
Difference: The former is an insert statement-by-record way | and relatively low efficiency, backup file is relatively large
     The latter is compressed for insert records | Relatively efficient and efficient
     

Backup MySQL database tasks regularly every day