mysql 数据库定时备份脚本，保留一周数据（7天）

sheel 脚本如下：

# back_data.sh

#!/bin/sh
#Author: Anne
#Date: 2021-10-12
#Desc: mysqldump the mysql

#Database info
dbuser="Anne"
dbpasswd="Anne@123"
dbhost="127.0.0.1"
dbport="3306"

#back data dir
BACK_DIR="/Anne/mysql_back"

#mysql home path
MySQL_HOME="/Anne/mysql5.7"

#back data log file
Log="$BACK_DIR/mysqlBack.log"

#mysqldump path
MYSQLDUMP_PATH="$MySQL_HOME/bin/mysqldump"

if [ ! -d $BACK_DIR ]
then
       mkdir -p $BACK_DIR
fi

#time info
time=` date +%Y%m%d%H `
time1=` date +%Y%m%d\ %H:%M:%S `
echo "$time1 start to full backup " >> $Log

$MYSQLDUMP_PATH -h $dbhost -P $dbport -u$dbuser -p$dbpasswd --flush-logs --master-data=2 --all-databases > $BACK_DIR/mysqlFull$time.sql

# 如果以上操作都执行成功
if [ $? -eq 0 ]
then
       time2=` date +%Y%m%d\ %H:%M:%S `
       echo "$time2 full backup successfully" >> $Log
else

       time2=` date +%Y%m%d\ %H:%M:%S `
       echo "$time2 full backup Faild" >> $Log
fi

spendTime=$(($(date +%s -d "$time2")-$(date +%s -d "$time1")))

echo "backup spend total time : $spendTime seconds" >> $Log

#remove 7 days ago backup
find $BACK_DIR -name "mysql*.sql" -mtime +7 -exec rm {} \;
echo "remove 7 days ago backup!" >>$Log

修改back_data.sh脚本为可执行权限

chmod 777 back_data.sh

将back_data.sh加入到定时文件里

# 查看当前定时脚本
crontab -l

# 打开定时文件
crontab -e

# 写入，每天凌晨4点钟自动开始备份
0 4 * * * /Anne/mysql_back/back_data.sh

# 重启定时服务
service sshd restart

定时服务安装参考连接：

crontab 安装和定时执行脚本_cocos2dGirl的专栏-CSDN博客