innobackupex --user=root --no-timestamp /root/full
4
innobackupex --user=root --no-timestamp --incremental --incremental-basedir=/root/full /root/inc
6
innobackupex --user=root --no-timestamp --incremental --incremental-basedir=/root/full /root/inc2
8
복원
innobackupex --apply-log --redo-only /root/full
innobackupex --apply-log --redo-only /root/full --incremental-dir= /root/inc
innobackupex --apply-log --redo-only /root/full --incremental-dir=/root/inc2
service mariadb stop
rm -rf /var/lib/mysql/*
innobackupex --copy-back /root/full
chown -R mysql:mysql /var/lib/mysql
service mariadb start
innobackupex --no-timestamp --user=root /root/full
innobackupex --apply-log --redo-only /root/full
to_lsn=`grep to_lsn /root/full/xtrabackup_checkpoints | awk '{ print $3 }'`
innobackupex --user=root --incremental --incremental-lsn=$to_lsn --no-timestamp /root/inc
innobackupex --apply-log --redo-only --incremental-dir=/root/inc /root/full
rm -rf /root/inc/*

댓글목록
등록된 댓글이 없습니다.