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