Difference between revisions of "Percona XtraBackup"
From DevOps Notebook
(Created page with "== Backup and restore with XtraBackup 8.0 == ''Note that credentials need to be in .my.cnf in home folder of running user'' Backup: <pre> $ xtrabackup --backup --target-dir=/p...") |
(No difference)
|
Revision as of 16:16, 21 March 2020
Backup and restore with XtraBackup 8.0
Note that credentials need to be in .my.cnf in home folder of running user Backup:
$ xtrabackup --backup --target-dir=/path/to/backups/ $ xtrabackup --prepare --target-dir=/path/to/backups/
Restore:
Backup needs to be prepared before it can be restored
Method 1:
$ xtrabackup --copy-back --target-dir=/path/to/backups/
Method 2:
$ rsync -avrP /path/to/backup/ /var/lib/mysql/ $ chown -R mysql:mysql /var/lib/mysql
