MySQL备份脚本

https://cloud.tencent.com/developer/information/mysqldump%E5%A4%87%E4%BB%BD%E4%B8%8D%E9%94%81%E8%A1%A8

#!/bin/bash
# 定义变量
DB_USER="root"
DB_PASS="your_password"
DB_NAME="your_database"
BACKUP_DIR="/backup/mysql"
DATE=$(date +%Y%m%d)

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

# 执行不锁表备份
mysqldump -u$DB_USER -p$DB_PASS \
  --single-transaction \
  --skip-lock-tables \
  --master-data=2 \
  --routines \
  --triggers \
  --events \
  $DB_NAME > $BACKUP_DIR/${DB_NAME}_${DATE}.sql

# 压缩备份文件
gzip $BACKUP_DIR/${DB_NAME}_${DATE}.sql

# 保留最近7天备份
# find $BACKUP_DIR -type f -name "*.gz" -mtime +7 -delete

MySQL备份脚本

评论区

MySQL备份脚本