export MDATE=`date +%Y%m%d`

export MDATE2=`date +%Y-%m-%d`

export USER="백업계정"

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

export HOST="아이피"

export BACKUPDIR="백업경로"  ## /백업디렉토리/INCREMENTAL

export LOGDIR="로그경로"


touch $LOGDIR/INCRE _TRANS_$MDATE.log

epxort LOG="$LOGDIR/INCRE_TRANS_$MDATE.log"



function INCREMENTALTRANS() {    

echo "-----"| tee -a $LOG
echo `date +%Y-%m-%d' '%H:%M:%S` >> $LOG
echo "TRANSPORT  START" >> $LOG
echo "----" >> $FULLLOG

/usr/local/bin/sshpass -p $PASSWORD /usr/bin/ssh -T -oStrictHostKeyChecking=no $USER@$HOST <<EOF1
mkdir -p $BACKUPDIR/$MDATE
EOF1
/usr/local/bin/sshpass -p $PASSWORD scp -r /maria_backup/incre/$MDATE2* $USER@$HOST:$BACKUPDIR/$MDATE/
}


INCREMENTALTRANS
if [ $? = "0" ]; then
echo `date +%Y-%m-%d' '%H:%M:%S` >> $LOG
echo "INCREMENTAL TRANSPORT COMPLETE" >> $LOG
else
echo `date +%Y-%m-%d' '%H:%M:%S` >> $LOG
echo "INCREMENTAL TRANSPORT FAILED" >> $LOG
fi


'mysql' 카테고리의 다른 글

incre.sh  (0) 2018.02.19
full_trans  (0) 2018.02.19
backup crontab  (0) 2018.02.19
full backup  (0) 2018.02.19

+ Recent posts