1，在/server/scripts/目录中创建备份脚本mysql_backup.sh
2，vim mysql_backup.sh #!/bin/bash #--------------------------- #Filename: mysql_backup.sh #Revision: 1.4 #Date: 2018/09/19 #Author: qc #Description: mysql backup every day delete before 7days. #Notes: This plugin uses the "" command #---------------------------- #Backup file is saved in the directory, if it does not exist Create
basepath='/data/mysql/backup/'
if [ ! -d "$basepath" ]; then mkdir -p "$basepath" fi
#mysql bakcup to /data/mysql/backup/ /usr/bin/mysqldump -uroot -p'12345678' --events --master-data=0 -B -A|gzip >$basepath/mysqlbak_$(date +%F).sql.gz
#Delete the backup data to 7 days before /usr/bin/find $basepath -mtime +7 -type f -name "*.sql.gz" -exec rm -rf {} ;
3，创建定时任务，每天凌晨2点执行此脚本 #crontab -e
#注释###### mysqldump backup mysql db ######
0 2 * * * /bin/sh /server/scripts/mysql_backup.sh &>/dev/null
4，注意事项 先在命令行里面测试，看是否成功，然后再写入定时任务脚本。
