#!/bin/bash

# 数据库配置
DB_HOST="localhost"
DB_USER="root"
DB_PASS="your_password"
DB_NAME="your_database"

# 备份目录配置
BACKUP_DIR="/backup/mysql"
DATE=$(date +%Y%m%d_%H%M%S)
BACKUP_FILE="$BACKUP_DIR/${DB_NAME}_$DATE.sql"

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

# 执行备份命令
mysqldump -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_FILE

# 检查备份是否成功
if 【 $? -eq 0 】; then
    echo "数据库备份成功: $BACKUP_FILE"
    
    # 删除7天前的备份文件
    find $BACKUP_DIR -name "*.sql" -mtime +7 -exec rm {} \;
else
    echo "数据库备份失败"
    exit 1
fi

# 每天凌晨2点执行备份
0 2 * * * /path/to/your/backup_script.sh