Changing storage engine of table in Mysql

Question

Currently the storage type of table is innodb , i want to add full text search on the table which is only possible on MYISAM engine. I tried using the command => alter table film engine = myisam; and got the error:

1217 - Cannot delete or update a parent row: a foreign key constraint fails

Help Please!! Thanks.

Answer 1

You must find the tables in the database that refer to this table through a FK constraint:

Identify the foreign key constraints for the table. Either use

SHOW CREATE TABLE `table_in_db_film`\G;

or

USE db_of_film_table;
SHOW TABLE STATUS LIKE 'film'\G

afterwards execute the necessary statements

ALTER TABLE film DROP FOREIGN KEY `ibfk_something`;

until you drop all constraints (of course replace ibfk_something with your constraint names). After this you should be able to alter the table engine.