Announcement

Announcement Module
Collapse
No announcement yet.

Can I restore one db from a full backup?

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

  • Can I restore one db from a full backup?

    Hello,

    I'm wondering if it's possible to restore a single database from a prepared full backup or is my only option for this granularity to backup each db individually?

  • #2
    Do you use file-per-table? If yes, see http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-table spaces.html (IMPORT TABLESPACE).

    Comment


    • #3
      Yes our MySQL servers are configured with the innodb_file_per_table setting. We also support or have myisam databases on our MySQL servers. Is it possible to restore a single db from a full innobackupex?

      Comment


      • #4
        So would the following method work for restoring a single db of either innodb or myisam?

        1. prepare the backup
        2. stop mysql
        3. copy the db directory to it's original location
        4. start mysql

        Comment


        • #5
          Step 2 & 4 are not necessary. For InnoDB see my last link, for MyISAM see http://stackoverflow.com/questions/1960845/mysql-backup-can- i-copying-individual-myisam-table-files-to-another-server-wi th

          Comment

          Working...
          X