How to convert MyISAM table to InnoDB table in Mysql

MyISAM and InnoDB are two popular storage engines. In some cases, it will be necessary to convert MyISAM table to InnoDB table. We can convert MyISAM table to InnoDB through commandline as well as phpmyadmin.

If you are using command line, follow the below steps.

Step1: Login to Mysql console

#mysql -u username -p

Step2: Select the database

mysql> use database;

Here we need to replace 'database' with the required db name.

Step3: Change the storage engine

mysql> ALTER TABLE tableName ENGINE=INNODB;

Here we need to replace 'tableName' with the required table name.

If you are using phpMyAdmin, follow the below steps.

Step1: Login to phpMyAdmin

Step2: Find your database and click on the table you want to convert

Step3: Click the "Operations" tab at the top

Step4: In the "Table options" box, change the Storage Engine to INNODB

Step5: Click "Go"
That's all....

Leave a Reply

Your email address will not be published. Required fields are marked *