ERROR 1025 (HY000): Error on rename of './test/#sql-2fa8_1' to './test/test2' (errno: 150)
... mysql> SET FOREIGN_KEY_CHECKS=0; Query OK, 0 rows affected (0.00 sec) mysql> SHOW CREATE TABLE my_table; ... KEY `my_index` (`my_column`), CONSTRAINT `bla_bla_bla` FOREIGN KEY (`my_column`) REFERENCES `another_table` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=212608 DEFAULT CHARSET=utf8 | +-------+------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------- -----------------------------------------------------------+ 1 row in set (0.00 sec) mysql> ALTER TABLE my_table DROP FOREIGN KEY bla_bla_bla; Query OK, 205474 rows affected (7.88 sec) Records: 205474 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE `my_table` DROP INDEX `my_index` mysql> SET FOREIGN_KEY_CHECKS=1; Query OK, 0 rows affected (0.00 sec)