【增量备份Mysql数据 - 备份binlog文件】

#!/bin/sh
/home/y/bin/mysqladmin flush-logs

DATADIR=/home/y ar/mysql/data
BAKDIR=/backup/mysql/daily

cd $DATADIR

FILELIST=`cat 1.index`

COUNTER=0
for file in $FILELIST
do
        let "COUNTER+=1"
done

NextNum=0
for file in  $FILELIST
do
        base=`basename $file`
        NextNum=`expr $NextNum + 1`
        if [ $NextNum -eq $COUNTER ]
        then
                echo "skip lastest"
        else
                dest=$BAKDIR/$base
                if(test -e $dest)
                then
                        echo "skip exist $base"
                else
                        echo "copying $base"
                        cp $base $BAKDIR
                fi
        fi
done
echo "backup mysql binlog ok"

 

转自黑夜路人