Changing storage engine in MySQL table

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;