mysql备份

MySQL数据库备份脚本

#!/bin/bash 
DATE=$(date +%F_%H-%M-%S) 
HOST=192.168.17.158 
DB=test 
USER=fenghahaha 
PASS=123456 
MAIL="zhangssan@example.com lisi@example.com" 
BACKUP_DIR=/data/db_backup 
SQL_FILE=${DB}_full_$DATE.sql BAK_FILE=${DB}_full_$DATE.zip 
cd $BACKUP_DIR 
if mysqldump -h$HOST -u$USER -p$PASS --single-transaction --routines --triggers -B $DB > $SQL_FILE;then 
	zip $BAK_FILE $SQL_FILE && rm -f $SQL_FILE 
	if [ ! -s $BAK_FILE ];then 
		echo "$DATE 内容" | mail -s "主题" $MAIL 
	fi 
else 
	echo "$DATE 内容" | mail -s "主题" $MAIL 
fi 
find $BACKUP_DIR -name '*.zip' -ctime +14 -exec rm {} \;