[RESOLVED] DISABLE KEYS not working?

[mrbaseball34]

I am importing some export scripts and before the table I'm having trouble I have this:

/*!40000 ALTER TABLE `ps_search_word` DISABLE KEYS */;

Then during import, I get this error:

Query: INSERT INTO `ps_search_word` (`id_word`, `id_lang`, `word`) VALUES (1660, 1, 'midknight');
MySQL: Duplicate entry '1-midknight' for key 'id_lang'

Just curious why it is ignoring the key being disabled?

TO be honest, I am actually dropping AND creating the table before the insert is even being done.

I can't find another insert record with those values, either.

Yes, I have Index privleges.

Any ideas?

[bradgrafelman]

mrbaseball34 wrote:

Just curious why it is ignoring the key being disabled?

It most likely isn't. The problem, however, is that DISABLE KEYS only affects non-unique indexes; the "id_lang" index doesn't fit that criteria.