mysql备份删除7天前的_mysqldump备份数据库，并删除7天前的备份文件脚本

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，注意事项

先在命令行里面测试，看是否成功，然后再写入定时任务脚本。