need informations fo restoring data

KoHeadKoHead ContributorInactive User Role Advisor
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

Dam

Comments

  • ernesto_vargasernesto_vargas Entrant Current User Role Participant
    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 Advisor
    ok.

    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.