1、編寫備份腳本：vim mysql_backup.sh?
#!/bin/bash
DATE=$(date +%Y%m%d_%H%M%S)
BACKUP_DIR="/data/mysql/backup"
USER="backup_user"
PASSWORD="backup**"# 邏輯備份所有數據庫
mysqldump -u$USER -p$PASSWORD ?eblp | gzip > $BACKUP_DIR/full_$DATE.sql.gz# 刪除7天前的備份
find $BACKUP_DIR -type f -mtime +7 -delete2、crontab -e
增加2點自動執行
0 2 * * * /data/mysql/mysql_backup.sh
)
