mysql dump 增量_Mysql数据备份与mysqldump增量备份

DATE=`date +%Y%m%d`

logFile=$daily_databak_dir/mysql$DATE.log

echo "     " > $eMailFile

echo "---------------------------------" >> $eMailFile

echo $(date +"%y-%m-%d %H:%M:%S") >> $eMailFile

echo "---------------------------------" >> $eMailFile

TIME=$(date "-d 10 day ago" +%Y%m%d%H%M%S)

StartTime=$(date "-d 1 day ago" +"%Y-%m-%d %H:%M:%S")

echo “Delete 10 days before the log ” >> $eMailFile

mysql -u$user -p"$passwd" -e "purge master logs before ${TIME}" && echo "delete 10 days before log" |tee -a $eMailFile   #删除10天前的2进制文件

filename=/data/`cat /data/mysql-bin.index |awk -F "/" '{print $2}'`   # 2进制文件

for i in $filename

do

echo "$StartTime start backup binlog " >> $eMailFile

mysqlbinlog -u$user -p$passwd -d $batabase --start-datetime="$StartTime" $i >> $daily_databak_dir/daily$DATE |tee -a $eMailFile

done

if [ $? = 0 ]

then

cd $daily_databak_dir

tar -zcvf $daily_databak_dir/$database$DATE.tar.gz daily$DATE >>/dev/null 2>&1

#scp $daily_databak_dir/$database$DATE.tar.gz