Re: scp replication

[Guilhem Bichot]

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