mysql增量备份脚本

#!/bin/bash

# 配置参数
DB_USER="your_db_user"
DB_PASS="your_db_password"
DB_NAME="your_db_name"
BACKUP_DIR="/path/to/backup/directory"
LOG_FILE="backup.log"

# 创建备份目录
mkdir -p $BACKUP_DIR

# 获取当前日期和时间
DATE=$(date +%Y%m%d%H%M%S)

# 获取上次备份的时间戳
LAST_BACKUP_TIMESTAMP=$(cat $BACKUP_DIR/last_backup_timestamp.txt 2>/dev/null)

# 如果没有上次备份时间戳，则设置为当前时间戳
if [ -z "$LAST_BACKUP_TIMESTAMP" ]; then
    LAST_BACKUP_TIMESTAMP=$DATE
fi

# 执行增量备份
mysqldump --user=$DB_USER --password=$DB_PASS --single-transaction --flush-logs --master-data=2 --skip-lock-tables --events --routines --triggers $DB_NAME > $BACKUP_DIR/incremental_backup_$DATE.sql

# 更新上次备份时间戳
echo $DATE > $BACKUP_DIR/last_backup_timestamp.txt

# 记录日志
echo "Incremental backup completed at $DATE" >> $LOG_FILE