Mysql : Cannot create Index:

Question

Hi all we are having trouble to create/drop index(s) on a table I keep getting the following error:

• ERROR 1280 (42000): Incorrect index name '<>'

Now the table has the following: 1. PRIMARY KEY (id), 2. UNIQUE KEY field_one (field_one), 3. KEY EAN (field_two),

Meta Info: - ENGINE=InnoDB AUTO_INCREMENT=23149997 DEFAULT CHARSET=utf8 MAX_ROWS=4294967295 AVG_ROW_LENGTH=50 PACK_KEYS=0

• About 20 000 000 entries.

Tried thus far: - check table (medium & extended) table is ok

• optimize table - went fine

• tried to drop all index(s) but that also doesn't work.

Server info: The server is a MASTER server is running MySQl 5(5.1.51-rel11.5-log) with Percona patches

Answer 1

Try without <>:

alter table MyTable drop index index-name;