To converting tables from one storage mechanism(engine) to another can be done by using the alter MySQL command

 ALTER TABLE table_name ENGINE = INNODB 

You can set the default storage engine to be used during the current session by setting the storage engine variable:

 SET storage_engine=INNODB 

Advertisements