备份MySQL并删除旧数据

backup_mysql.sh

#!/bin/bash
baseDir="/data/backup/mysql";
userName="root"
password="123456"
host="127.0.0.1"

backup() {
  echo "开始备份数据库: $1"
  mysqldump -h$host -u$userName -p$password --default-character-set=utf8 $1 | gzip > $baseDir/$1_dump_$(date +%Y%m%d_%H%M%S).sql.tar.gz
  echo "备份数据完成";
}

backup ApolloDB

oldDate=`date --date='8 day ago' +%Y%m%d`;
#删除当前日期-8的备份
rm -rf $baseDir/*_dump_$oldDate*;
echo "删除$oldDate的备份成功"

# 添加到crontab：1 0 * * * root /data/backup/mysql_backup.sh