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 |