Hi,
We'd like to be able to move certain innodb databases between machines
(some, but not all). This would help greatly with resyncing slaves and
for fast backups. I know that we can create table-spaces on a per-table
basis as described here.
http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html
It also says that we cannot freely move tables between database
directories like in MyISAM, but we can restore backups of .ibd files. Is
there any way to move the .ibd files from one machine to another? Is
there dependency on the shared tablespace and the corresponding .ibd file?
i.e. can we copy a .ibd file to another machine and "import tablespace"
on it?
Any input would be appreciated. thanks!
Brandon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]