Changing storage engine in MySQL table

Posted on by

Problem

You want to change the storage engine in one or more of your MySQL tables, for example when you want to use a FULLTEXT index, that is not supported in INNODB tables in MySQL versions before 5.6.

Solution

Use the following to change the storage engine

ALTER TABLE table_name ENGINE = MyISAM;