BINLOG Incremental Backup

#! /Bin/bashloglast = 'cat/var/lib/MySQL/localhost-bin.index | awk-F "/" '{print $2}' | tail-N 1' // fetch is in use BINLOG log if [! -E/binlogdir]; then mkdir/binlogdirfifor I in 'cat/var/lib/MySQL/localhost-bin.index | awk-F "/" '{print $2} ''// traverse all BINLOG logs do LOGNAME = 'echo $ I 'CD/var/lib/MySQL if [-E/binlogdir/$ LOGNAME]; then // determine whether the BINLOG to be backed up already exists in this directory. If so, stop this loop. Continue else if [$ loglast! = $ LOGNAME]; then // determine whether the BINLOG to be backed up is using CP $ LOGNAME/binlogdirfifidone

 

BINLOG Incremental Backup