MySQL Forums :: Cluster :: Moving database from MYISAM to NDB errno: 707
Moving database from MYISAM to NDB errno: 707
Posted by: Rosario Arun
Date: January 20, 2010 02:44AM
I want to move a database from a normal MyISAM DB to NDB. I took a dump and renamed the engine to ndbcluster and then then exported to the NDB. Out of 92 tables it creates 22 tables and stops with the error
#1005 - Can't create table '<tablename>' (errno: 707)
#1005 - Can't create table '<tablename>' (errno: 157)
If i use php my admin
#1005 - Can't create table '<tablename>' (errno: 157) (<a href="server_engines.php?engine=InnoDB&page=Status&token=efec9301c381679286dc79a5be986533">Details...</a>)
I tried to create a table manually, it worked fine. But if i copy the CREATE TABLE querry from the dump file with engine ndbcluster. i get the above error.
Please help me
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.