Brandon,
sorry, you cannot move .ibd files between installations. The ability to do
so is in the TODO, but I cannot promise any release date.
Currently, the only way to move individual InnoDB tables between
installations is the dump + import method.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: HOTorNOT Tech [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 11, 2006 3:10 AM
Subject: InnoDB per-table-space backup and move
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
