Not the answer you need?
Register and ask your own question!

Get rid of ibdata1 using xtrabackup?

tdelnattetdelnatte EntrantCurrent User Role Beginner
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

Comments

  • tdelnattetdelnatte Entrant Current User Role Beginner
    What do you think about switch every table to myisam, clear ibdata1 and turn back tables to innodb then?.
    What about foreign keys?
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.