need informations fo restoring data

MySQL & MariaDB Percona XtraBackup
1

Hi all,

I have some questions about the restore process of data with innobackup and xtrabackup.

The restart of mysql server is mandatory ?

This step is also mandatory ?

sudo mv /var/lib/mysql /var/lib/mysql-old$ sudo cp -R /var/backups/mysql/2011-03-19_19-08-58 /var/lib/mysql$ sudo chown -R mysql:mysql /var/lib/mysql

I must necesseraly destroy the datadir ? entirely ?

Thank you

Dam

2

You MUST stop mysql before restoring you backup.

Do the 3 steps you mention before. Then run “innobackupex --apply-log --use-memory=2G /var/lib/mysql”

Then restart mysql.

3

ok.

Thank you for answer !