David Sparks wrote: > 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
Oh no! http://bugs.mysql.com/bug.php?id=5904 [5 Oct 2004 20:04] John David Duncan Description: Allow ALTER TABLE t IMPORT TABLESPACE to import a tablespace created on some other MySQL server. This requires changing the tablespace number (unless it is available...) and resetting the transaction identifiers in the imported .ibd file. --->%--- Argh! Note that "some other MySQL server" above applies to the same hardware and just a different mysql instance. ie If you're trying to restore from backup. Import tablespace has little use without being able to move the files between server instances. :( ds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
