MySQL Forums
Forum List  »  Replication

Re: scp replication
Posted by: Guilhem Bichot
Date: December 14, 2004 03:01PM

There it says you can have each table in its own tablespace, but, it won't solve your problem because if you copy the .ibd files of all tables of the database you want to copy, restoring that on the new server will not work properly ("You cannot freely move `.ibd' files around between database directories the way you can with MyISAM table files. This is because the table definition is stored in the InnoDB shared tablespace, and also because InnoDB must preserve the consistency of transaction IDs and log sequence numbers.").
Copying and restoring .ibd files work as long as this is done on the mysqld server where the .ibd were created.

Options: ReplyQuote

Written By
November 26, 2004 04:20AM
Re: scp replication
December 14, 2004 03:01PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.