Announcement

Announcement Module
Collapse
No announcement yet.

Get rid of ibdata1 using xtrabackup?

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

  • Get rid of ibdata1 using xtrabackup?

    Hi,

    I try to find a way to get rid of ibdata1 using Xtrabackup on a Terrabyte database.

    I want to restore my database on a slave with option "innodb_file_per_table=1" without ibdata1 tablespace.

    Is it possible with xtrabackup?

    Thanks

  • #2
    What do you think about switch every table to myisam, clear ibdata1 and turn back tables to innodb then?.
    What about foreign keys?
    Last edited by tdelnatte; 04-04-2014, 12:45 PM.

    Comment

    Working...
    X