I want to move 3 100GB .ibd files into a new DB. I followed the instructions here:
http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html But it doesn't work: mysql> alter table reports discard tablespace; Query OK, 0 rows affected (0.04 sec) mysql> alter table reports import tablespace; ERROR 1030 (HY000): Got error -1 from storage engine mysqld.err says: 061206 14:57:35 InnoDB: Error: tablespace id in file './money/reports.ibd' is 88, but in the InnoDB InnoDB: data dictionary it is 34. InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.html InnoDB: for how to resolve the issue. 061206 14:57:35 InnoDB: cannot find or open in the database directory the .ibd file of InnoDB: table `money/reports` InnoDB: in ALTER TABLE ... IMPORT TABLESPACE How to fix this? ds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
