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="/path/to/backup/logfile.log"

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

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

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

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

# 清理旧的binlog文件（可选）
find $BACKUP_DIR -name "incremental_backup_*.sql" -mtime +7 -exec rm {} \;