MySQL Forums
Forum List  »  NDB clusters

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
4144
January 20, 2010 02:44AM


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.