mariaDB xtrabackup

#풀백업

innobackupex --defaults-file=/etc/my.cnf --user=root --password=패스워드 --no-timestamp /app/DBBackup/Full

innobackupex --apply-log --redo-only /app/DBBackup/Full

#증분백업

to_lsn=`grep to_lsn /app/DBBackup/Full/xtrabackup_checkpoints | awk '{ print $3 }'`

innobackupex --user=root --password=패스워드 --incremental --incremental-lsn=$to_lsn --no-timestamp /app/DBBackup/Incremental-dir

#풀백업에 증분백업 엎기

innobackupex --apply-log --redo-only --incremental-dir=/app/DBBackup/Incremental-dir /app/DBBackup/Full

#엎고 증분백업 지우기

rm -rf /app/DBBackup/Incremental-dir

#복구

innobackupex --apply-log /app/DBBackup/Full

innobackupex --copy-back /app/DBBackup/Full