Čia matote skirtumus tarp pasirinktos versijos ir esamo dokumento.
Last revision Both sides next revision | |||
xtrabackup [2015/07/20 17:17] dalius sukurtas |
xtrabackup [2015/07/20 17:18] dalius |
||
---|---|---|---|
Linija 1: | Linija 1: | ||
- | CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 'bkppassword';\\ | + | ''CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 'bkppassword';\\ |
GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost';\\ | GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost';\\ | ||
- | FLUSH PRIVILEGES;\\ | + | FLUSH PRIVILEGES;''\\ |
- | innobackupex --user=bkpuser --password=bkppassword --no-timestamp /tmp/base_backup/\\ | + | ''innobackupex --user=bkpuser --password=bkppassword --no-timestamp /tmp/base_backup/''\\ |
- | JEI reikia preparint: innobackupex --apply-log --redo-only /tmp/base_backup\\ | + | JEI reikia preparint: ''innobackupex --apply-log --redo-only /tmp/base_backup''\\ |
Incremental:\\ | Incremental:\\ | ||
- | innobackupex --user=bkpuser --password=bkppassword --incremental --incremental-basedir=/tmp/base_backup/ /tmp/\\ | + | ''innobackupex --user=bkpuser --password=bkppassword --incremental --incremental-basedir=/tmp/base_backup/ /tmp/''\\ |
Preparint incremental:\\ | Preparint incremental:\\ | ||
- | innobackupex --apply-log --redo-only /tmp/base_backup --incremental-dir=2015_\\ | + | ''innobackupex --apply-log --redo-only /tmp/base_backup --incremental-dir=2015_''\\ |
viskas atsiranda base_backup\\ | viskas atsiranda base_backup\\ | ||
Linija 17: | Linija 17: | ||
Restore:\\ | Restore:\\ | ||
- | innobackupex --copy-back /tmp/base_backup\\ | + | ''innobackupex --copy-back /tmp/base_backup''\\ |