User Tools
xtrabackup
Skirtumai
Čia matote skirtumus tarp pasirinktos versijos ir esamo dokumento.
| Next revision | Previous revision | ||
|
xtrabackup [2015/07/20 17:17] dalius sukurtas |
xtrabackup [2015/07/20 17:20] 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''\\ |
xtrabackup.txt · Keista: 2015/07/20 17:20 vartotojo dalius
