欧美亚洲一区二区三区-欧美亚洲一区-欧美亚洲一二三区-欧美亚洲香蕉-欧美亚洲网站-欧美亚洲网

#!/bin/bash

# 數(shù)據(jù)庫配置
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"

# 創(chuàng)建備份目錄
mkdir -p $BACKUP_DIR

# 執(zhí)行備份命令
mysqldump -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_FILE

# 檢查備份是否成功
if 【 $? -eq 0 】; then
    echo "數(shù)據(jù)庫備份成功: $BACKUP_FILE"
    
    # 刪除7天前的備份文件
    find $BACKUP_DIR -name "*.sql" -mtime +7 -exec rm {} \;
else
    echo "數(shù)據(jù)庫備份失敗"
    exit 1
fi

# 每天凌晨2點(diǎn)執(zhí)行備份
0 2 * * * /path/to/your/backup_script.sh