Convert MySql database tables types from MyISAM to InnoDB

Conversion on dump file

If you have a dump file of mysql, The easiest way is to run the command on the dump file. It will replace the tables from MyISAM to INNODB

You can also change the command and convert INNODB to MyISAM by this command

 

 

Conversion on current database

If you want to convert MyISAM to InnoDB on the fly. The following is the procedure.

We will query and list the database tables and build the list of alter statements which will update the database tables.

Once you have the list of queries. You can copy and executes these statements to alter database.