User Tools

Site Tools


xtrabackup

Čia yra sena dokumento versija!


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

xtrabackup.1437401881.txt.gz · Keista: 2015/07/20 17:18 vartotojo dalius