This post will show you how to change a storage engine of a MySQL table to another engine.

1) For SQLYog software users:
select a table you want to change the storage engine, then click on Table tab, select Alter Table. Then click on Advanced Properties. You will see a dialog box as seen below, select Table type drop down box, and select an engine you wish for that specific table.

2) For PHPMyAdmin users:
select database, select a table that you want to change the engine. Then click on Operations tab, you will see the Table Options panel. Select the Storage Engine dropdown box, now you can select the engine type you want for that table.

3) For MySQL command users:
if you wish to change the “customers” table from MyISAM to INNODB, select the database, select the table, then run this SQL query againt the table:

ALTER TABLE customers ENGINE = innodb;

Remember that the storage engine type is not case sensitive.