need informations fo restoring data

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


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.


Thank you for answer !