凌晨2点自动备份mysql 数据库，mysql_backup.sh

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 -delete

2、crontab -e

增加2点自动执行

0 2 * * * /data/mysql/mysql_backup.sh