Re: Convert InnoDB to MyiSAM

[Rick James]

First, I must ask "why" you want to convert to MyISAM. There are very few use cases where MyISAM might be better than InnoDB.

As for FOREIGN KEYs, ... It implicitly creates an index; you probably need the index after the conversion, so make sure it is still there after the conversion.

Plan A: Use mysqldump to dump the schema and data. Edit that output to remove "FOREIGN KEY ..." and change "ENGINE=...". Then load the file using "mysql".

Plan B:
CREATE TABLE t_myisam LIKE t_innodb;
ALTER TABLE
DROP FOREIGN KEY ...,
...,
ENGINE=InnoDB;

(I may have left out some details, but hopefully I have pointed you the right direction.)