定期备份MySQL数据库

#!/bin/bash

# MySQL配置
USER="root"
PASSWORD="yourpassword"
DATABASE="yourdatabase"

# 备份路径
BACKUP_DIR="/path/to/backup"
DATE=$(date +"%Y%m%d%H%M")

# 创建备份
mysqldump -u $USER -p$PASSWORD $DATABASE > $BACKUP_DIR/$DATABASE-$DATE.sql

# 删除超过7天的备份文件
find $BACKUP_DIR -type f -name "*.sql" -mtime +7 -exec rm {} \;

# 日志记录
echo "Backup and cleanup completed on $(date)" >> $BACKUP_DIR/backup.log