MySQL Forums
Forum List  »  Replication

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

Hi,
http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html
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.
Guilhem

Options: ReplyQuote


Subject
Views
Written By
Posted
5606
November 26, 2004 04:20AM
Re: scp replication
3517
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.