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 (
2. UNIQUE KEY
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