GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Innobackupex question

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

  • Innobackupex question

    I know its possible to backup individual schemas with innobackupex but how do you restore an individual schema without affecting the others? Do I just copy the backup directory structure and files into the working mysql directory?



  • #2
    For MyISAM yes, but for InnoDB see http://www.percona.com/doc/percona-x...ables_ibk.html

    Comment


    • #3
      The process depends on if you are using MyISAM or InnoDB/XtraDB, but below are links to the manual with important information and steps on both taking the partial backup, preparing it, and restoring it:

      http://www.percona.com/doc/percona-x...obackupex.html

      http://www.percona.com/doc/percona-x...ables_ibk.html

      Comment


      • #4
        thanks for the info. very helpful

        Comment

        Working...
        X