#!/bin/sh
#name: mysqlfullbackup.sh
#PS:mysql database full backup
#Write by:i.Stone
#use mysqldump --help get more detail
scriptsDir='pwd'
#mysqlDir=/var/lib/mysql
mysqlDir=/usr/bin/mysql
user=root
passPWD=123456
dataBackupDir=/tmp/mysqlback
eMailFile=$dataBackupDir/email.txt
eMail=mail@163.com
logFile=$dataBackupDir/mysqlbackup.log
DATE="$(date -I)"
echo "" > $eMailFile
echo $(date +"%y-%m-%d %H:%M:%S") >> $eMailFile
cd $dataBackupDir
dumpFile=mysql.$DATE.sql
GZDumpFile=mysql.$DATE.sql.tar.gz
/usr/bin/mysqldump -u $user -p$passPWD --opt --default-character-set=utf8 --extended-insert=false --triggers -R --hex-blob --all-databases --flush-logs --delete-master-logs -x > $dumpFile
if [[ $? == 0 ]];then
tar zcf $GZDumpFile $dumpFile >> $eMailFile 2>&1
echo "BackupFilename:$GZDumpFile" >> $eMailFile
echo "DataBase Backup Success!" >> $eMailFile
rm -f $dumpFile
#delete daily backup files.
cd $dataBackupDir/daily
rm -rf *
#Delete old backup files(mtime>2)
$scriptsDir/rmBackup.sh
#Move Backup Files To Backup Server
$scriptsDir/rsyncBackup.sh
if (( !$? ));then
echo "Move Backup Files To Backup Server Success!" >> $eMailFile
else
echo "Move Backup Files To Backup Server Fail!" >> $emailFile
fi
else
echo "DataBase Backup Fail!" >> $eMailFile
fi
echo "------------------------------------------------------------" >> $logFile
cat $eMailFile >> $logFile
cat $eMailFile | mail -s "Mysql Backup" $eMail
本文转自 zhuxtqw 51CTO博客，原文链接：http://blog.51cto.com/1054054/1703246，如需转载请自行联系原作者
