Not the answer you need?
Register and ask your own question!

need informations fo restoring data

KoHeadKoHead ContributorInactive User Role Beginner
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</pre>

I must necesseraly destroy the datadir ? entirely ?

Thank you



  • ernesto_vargasernesto_vargas Entrant Current User Role Beginner
    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.
  • KoHeadKoHead Contributor Inactive User Role Beginner

    Thank you for answer !
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.