wiki.laukas.lt

CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 'bkppassword';
GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost';
FLUSH PRIVILEGES;

innobackupex --user=bkpuser --password=bkppassword --no-timestamp /tmp/base_backup/
JEI reikia preparint: innobackupex --apply-log --redo-only /tmp/base_backup

Incremental:
innobackupex --user=bkpuser --password=bkppassword --incremental --incremental-basedir=/tmp/base_backup/ /tmp/
Preparint incremental:
innobackupex --apply-log --redo-only /tmp/base_backup --incremental-dir=2015_

viskas atsiranda base_backup

Restore:

innobackupex --copy-back /tmp/base_backup