Percona XtraBackup

Backup and restore with XtraBackup 8.0

Note that credentials need to be in .my.cnf in home folder of running user

Backup with Percona XtraBackup 8.0

$ xtrabackup --backup --target-dir=/path/to/backups/
$ xtrabackup --prepare --target-dir=/path/to/backups/

=== Restore with Percona XtraBackup 8.0 ===
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