#!/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"