Skip navigation links

MySQL Forums :: Cluster :: Moving database from MYISAM to NDB errno: 707


Advanced Search

Moving database from MYISAM to NDB errno: 707
Posted by: Rosario Arun ()
Date: January 20, 2010 02:44AM

Hi All,
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)

or

#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&amp;page=Status&amp;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

Options: ReplyQuote


Subject Views Written By Posted
Moving database from MYISAM to NDB errno: 707 3299 Rosario Arun 01/20/2010 02:44AM
Re: Moving database from MYISAM to NDB errno: 707 1630 Andrew Morgan 01/20/2010 10:18AM


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.