#!/bin/bash
# 定义备份参数
number=31
backup_dir=/root/mysqlbackup
dd=`date +%Y-%m-%d`
tool=docker exec -i mysql mysqldump
username=root
password=123456
database_name=dbname

# 如果备份目录不存在，则创建
if [ ! -d $backup_dir ]; then
  mkdir -p $backup_dir;
fi

# 执行mysqldump命令备份数据库
docker exec -i mysql mysqldump -u$username -p$password. $database_name>$backup_dir/bangong_$dd.sql


# 记录备份日志
echo "create $backup_dir/$database_name-$dd.sql" >> $backup_dir/log.txt

# 删除超过设定天数的备份文件
count=`ls -l -crt $backup_dir/*.sql | awk '{print $9 }' | wc -l`
if [ $count -gt $number ]; then
  delfile=`ls -l -crt $backup_dir/*.sql | awk '{print $9 }' | head -1`
  rm $delfile
  echo "delete $delfile" >> $backup_dir/log.txt
fi