I'm about to drop an index from a mySQL INNODB table. There are references defined already. When I try to alter it, it says:
#1025 - Error on rename of 'X/#sql-2a5f_219828' to 'X' (errno: 150)
Which at first seems logical, since there are relations, it can't be renamed. But even if I disable foreign key checking:
SET foreign_key_checks = 0;
ALTER TABLE flyers DROP INDEX Index_5, ROW_FORMAT = DYNAMIC;
I get the same! I don't want to drop ALL foreign key definitions, drop that index, and define them again! Another solution?