MySQL备份01

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67

[root@mysql-master scripts]# cat  mysql_backup.sh #!/bin/bash   # MySQL连接信息 mysql_user="root" mysql_password="Abcd0713@2024" mysql_defaults_file="/etc/my.cnf"   # 备份目录 backup_dir="/data/backup"   # 获取当前日期和星期几 current_date=$(date +"%Y-%m-%d") current_day=$(date +"%u")  # %u 格式返回的星期几为 1（周一）到 7（周日）   # 检查备份目录是否存在 if [ ! -d "$backup_dir" ]; then     mkdir $backup_dir fi   # 确定是否需要执行全量备份 if [ ! -f "$backup_dir/last_full_backup_info.txt" ]; then     echo "执行初始全量备份。"     full_backup_dir="$backup_dir/full_backup_$current_date"     xtrabackup --defaults-file="$mysql_defaults_file" --user="$mysql_user" --password="$mysql_password" --backup --target-dir="$full_backup_dir"     if [ $? -eq 0 ]; then         echo "$(date) - 全量备份成功。" >> "$backup_dir/backup_log.txt"     else         echo "$(date) - 全量备份失败。" >> "$backup_dir/backup_log.txt"     fi     echo "$current_date" > "$backup_dir/last_full_backup_info.txt"     exit 0 fi   last_full_backup_date=$(cat "$backup_dir/last_full_backup_info.txt")   if [ $current_day -eq 7 ]; then     echo "星期天执行全量备份。"     full_backup_dir="$backup_dir/full_backup_$current_date"     xtrabackup --defaults-file="$mysql_defaults_file" --user="$mysql_user" --password="$mysql_password" --backup --target-dir="$full_backup_dir"     if [ $? -eq 0 ]; then         echo "$(date) - 全量备份成功。" >> "$backup_dir/backup_log.txt"     else         echo "$(date) - 全量备份失败。" >> "$backup_dir/backup_log.txt"     fi     echo "$current_date" > "$backup_dir/last_full_backup_info.txt" else     incremental_backup_dir="$backup_dir/incremental_backup_$current_date"     echo "根据上次全量备份于 $last_full_backup_date 执行增量备份。"     xtrabackup --defaults-file="$mysql_defaults_file" --user="$mysql_user" --password="$mysql_password" --backup --target-dir="$incremental_backup_dir" --incremental-basedir="$backup_dir/full_backup_$last_full_backup_date"     if [ $? -eq 0 ]; then         echo "$(date) - 增量备份成功。" >> "$backup_dir/backup_log.txt"     else         echo "$(date) - 增量备份失败。" >> "$backup_dir/backup_log.txt"     fi fi   echo "备份完成。"   # 获取两周前的日期 two_weeks_ago=$(date -d '2 weeks ago' +"%Y-%m-%d")   # 删除两周前的备份文件 find $backup_dir -type d -name "full_backup_*" -ctime +14 -exec rm -r {} \; find $backup_dir -type d -name "incremental_backup_*" -ctime +14 -exec rm -r {} \;   echo "$(date) - 删除两周前的备份文件。" >> "$backup_dir/backup_log.txt"