Converting to MyISAM, `foreign_key_checks = 0` Not Working
Here's a method you can use without dumping all your InnoDB tables.

You will have to drop the foreign key constraints before you can alter the tables. You can generate the drop statements using the INFORMATION_SCHEMA this way:

mysql&gt; SELECT CONCAT('ALTER TABLE `', table_schema, '`.`', table_name, 
    '` DROP FOREIGN KEY `', constraint_name, '`;') AS _sql 
  FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE 
  WHERE referenced_table_schema = 'mydb' -- replace with your database name
    AND referenced_table_name = 'catalog_category_entity' 
    AND ordinal_position = 1;


The output should be one or more a fully-formed DDL statements. Run the statements, and then you can change the storage engine for your parent table.