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"