incre.sh

export DATE=`date +%Y%m%d%H%M%S`

export USER="백업계정"

export PASSWD="백업계정비밀번호"

export PORT="포트숫자"

export BACKUPDIR="백업경로" ##기존 full.sh 백업경로

export DBCONF="/etc/my.cnf"

export FULLDIR="백업경로/full/" 

export INCDIR="$BACKUPDIR/incre"

export HOST="서버아이피"

if [ "$INCDIR" = "" ]; then

mkdir -p $BACKUPDIR/incre

fi

export INCLOGDIR="$BACKUPDIR/increlogs"

if [ "$INCLOG" = "" ]; then

mkdir -p $BACKUPDIR/increlogs/

touch $INCLOGDIR/incre_$DATE.log

export INCOG="$INCLOGDIR/incre_$DATE.log"

fi

function INCBACKUP() {

echo "-----"| tee -a $INCLOG

echo `date +%Y-%m-%d' '%H:%M:%S` >> $INCLOG

echo "BACKUP START" >> $INCLOG

echo "-----" >> $INCLOG

innobackupex --defaults-file=$DBCONF --user=$USER --password=$PASSWD --host==$HOST --port=$PORT --parallel=4 --tmpdir=$FULLDIR/tmp --extra-lsndir=$FULLDIR/tmp --incremental --incremental-basedir=$FULLDIR $INCDIR

}

INCBACKUP 

if [ $? = "0" ]; then

echo `date +%Y-%m-%d' '%H:%M:%S` >> $INCLOG

echo "BACKUP COMPLETE" >> $INCLOG

else

echo `date +%Y-%m-%d' '%H:%M:%S` >> $INCLOG

echo "BACKUP FAILED" >> $INCLOG

fi