Dear Gurus,
I am trying to import a table that works fine under myISAM but does
not work when I change the ENGINE=NDBCLUSTER. I get the following
error:
#1005 - Can't create table './test/xcart_customers.frm' (errno: 4242)
A lot of googling has told me that means that there are too many indes
and advises me to "Try and increase MaxNoOfUniqueIndexes and/or
MaxNoOfOrderedIndexes" and I have now got this in my config.ini:
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory = 200MB
IndexMemory = 100MB
MaxNoOfOrderedIndexes = 100
I can not set MaxNoOfUniqueIndexes - it tells me that there is no such
option in config.ini.
However, despite this, when I try to start ndb_mgmd I still get the error.
Can someone point me in the right direction and tell me what I am doing wrong?
The dump follows:
CREATE TABLE `xcart_customers` (
`login` varchar( 32 ) NOT NULL default '',
`usertype` char( 1 ) NOT NULL default '',
`membership` varchar( 32 ) NOT NULL default '',
`password` varchar( 128 ) NOT NULL default '',
`password_hint` varchar( 128 ) NOT NULL default '',
`password_hint_answer` varchar( 128 ) NOT NULL default '',
`b_address` varchar( 64 ) NOT NULL default '',
`b_city` varchar( 64 ) NOT NULL default '',
`b_county` varchar( 32 ) NOT NULL default '',
`b_state` varchar( 32 ) NOT NULL default '',
`b_country` char( 2 ) NOT NULL default '',
`b_zipcode` varchar( 32 ) NOT NULL default '',
`title` varchar( 32 ) NOT NULL default '',
`firstname` varchar( 128 ) NOT NULL default '',
`lastname` varchar( 128 ) NOT NULL default '',
`company` varchar( 255 ) NOT NULL default '',
`s_address` varchar( 255 ) NOT NULL default '',
`s_city` varchar( 255 ) NOT NULL default '',
`s_county` varchar( 32 ) NOT NULL default '',
`s_state` varchar( 32 ) NOT NULL default '',
`s_country` char( 2 ) NOT NULL default '',
`s_zipcode` varchar( 32 ) NOT NULL default '',
`email` varchar( 128 ) NOT NULL default '',
`phone` varchar( 32 ) NOT NULL default '',
`fax` varchar( 32 ) NOT NULL default '',
`url` varchar( 128 ) NOT NULL default '',
`card_name` varchar( 255 ) NOT NULL default '',
`card_type` varchar( 16 ) NOT NULL default '',
`card_number` varchar( 42 ) NOT NULL default '',
`card_expire` varchar( 4 ) NOT NULL default '',
`card_cvv2` char( 3 ) NOT NULL default '',
`last_login` int( 11 ) NOT NULL default '0',
`first_login` int( 11 ) NOT NULL default '0',
`status` char( 1 ) NOT NULL default 'Y',
`referer` varchar( 255 ) NOT NULL default '',
`pending_membership` varchar( 32 ) NOT NULL default '',
`ssn` varchar( 32 ) NOT NULL default '',
`language` char( 2 ) NOT NULL default 'US',
`cart` mediumtext NOT NULL ,
`change_password` char( 1 ) NOT NULL default 'N',
`parent` varchar( 32 ) NOT NULL default '',
`pending_plan_id` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `login` ) ,
UNIQUE KEY `login` ( `login` ) ,
KEY `usertype` ( `usertype` ) ,
KEY `membership` ( `membership` ) ,
KEY `last_login` ( `last_login` ) ,
KEY `first_login` ( `first_login` ) ,
KEY `status` ( `status` )
) ENGINE = NDBCLUSTER DEFAULT CHARSET = ascii
