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
)
