I'm getting an error while migrating a database from mysql 5.0 MyISAM to MySQL 5.0 NDBCLUSTER. The problem comes when i try to move tables with multiple keys. I've looked through the documentation and noted that it doesn't support foreign keys, but MyISAM also doesn't support foreign keys and there are no foreign keys on the tables in question. Each of the tables is a little different. The first table I noticed it on had a primary key and a single column unique key. The next table has a primary key, a three column unique key, a two column key and a single column key. There are a few other tables as well that feature similar keys mostly single or multicolumn unique keys or single or multicolumn keys. I will also note that there is only one auto_increment variable defined in the table and that is the primary key. The error that is generated when i try:

ALTER TABLE foo ENGINE=NDBCLUSTER;

is the following:

ERROR 1005 (HY000): Can't create table './login/#sql-41a_3752.frm' (errno: 4242)

When I use the SHOW ERROR command i get this:

+-------+------+--------------------------------------------------------------+ | Level | Code | Message | +-------+------+--------------------------------------------------------------+ | Error | 1296 | Got error 4242 'Too many indexes' from NDB | | Error | 1005 | Can't create table './login/#sql-41a_3752.frm' (errno: 4242) | +-------+------+--------------------------------------------------------------+

and a similar result from perror: perror --ndb 4242

NDB error code 4242: Too many indexes: Permanent error: Application error

Many thanks in advance for the help.