GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

need informations fo restoring data

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

    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.

    Comment


    • #3
      ok.

      Thank you for answer !

      Comment

      Working...
      X