#!/bin/bash
# Program
# use mysqldump to Fully backup mysql data per week!
# History
# Path
BakDir=/data/mysql_back
LogFile=/data/mysql_back/bak.log
Date=`date +%Y%m%d`
Begin=`date +"%Y年%m月%d日 %H:%M:%S"`
cd $BakDir
DumpFile=$Date.sql
GZDumpFile=$Date.sql.tgz
/usr/local/mysql/bin/mysql -uroot -pxxxxxxx --socket=/tmp/mysql.sock -e "show databases;" | grep -Ev "Database|mysql|test|performance_schema|information_schema" | xargs /usr/local/mysql/bin/mysqldump --flush-privileges --single-transaction --master-data=2 --triggers -f -R -E --hex-blob -uroot -ponlinedown.net --socket=/tmp/mysql.sock --databases > $DumpFile
tar czvf $GZDumpFile $DumpFile
rm $DumpFile
Last=`date +"%Y年%m月%d日 %H:%M:%S"`
echo 开始:$Begin 结束:$Last $GZDumpFile succ >> $LogFile
cd $BakDir/daily
#rm -rf *
mv /data/mysql_back/*.tgz /data/mysql_back/his
find /data/mysql_back/his -name "*.tgz" -mtime +35 |xargs rm -rf