#!/bin/bash
# 配置參數
BACKUP_DIR="/var/backups"
DB_USER="root"
DB_PASSWORD="your_password"
DB_NAME="your_database"
WEB_DIR="/var/www/html"
DATE=$(date +"%Y%m%d")
# 創建備份目錄
mkdir -p "$BACKUP_DIR/$DATE"
# 備份MySQL數據庫
mysqldump -u "$DB_USER" -p"$DB_PASSWORD" "$DB_NAME" > "$BACKUP_DIR/$DATE/$DB_NAME.sql"
tar -czf "$BACKUP_DIR/$DATE/$DB_NAME.sql.tar.gz" -C "$BACKUP_DIR/$DATE" "$DB_NAME.sql"
rm "$BACKUP_DIR/$DATE/$DB_NAME.sql"
# 備份網站文件
tar -czf "$BACKUP_DIR/$DATE/web_backup.tar.gz" -C "$WEB_DIR" .
# 清理舊備份
find "$BACKUP_DIR" -type d -mtime +7 -exec rm -rf {} \;
echo "Backup completed for $DATE"
