# BACKUP
systemctl start [email protected]
xtrabackup --backup --target-dir=/var/backup/xtrabackup/full/
xtrabackup --prepare --target-dir=/var/backup/xtrabackup/full/
# RESTORE
systemctl stop [email protected]
rm -rf /var/lib/mysql/*
xtrabackup --copy-back --target-dir=/var/backup/xtrabackup/full/
rsync -avrP /var/backup/xtrabackup/full/ /var/lib/mysql/
chown -R mysql:mysql /var/lib/mysql
systemctl start [email protected]