Change table type from MyISAM to InnoDB using phpMyAdmin
phpMyAdmin is a tool for handling the administration of MySQL over the web. It can perform various tasks such as creating, modifying, deleting the databases, tables and the fields and also can be used for executing SQL statements, managing users, and permissions. To change table type from MyISAM to InnoDB, follow the below steps
Step 2: Go to Database Section and select the option phpMyAdmin
Step 3: On the left pane of the phpMyAdmin Main Page, it displays the list of available Databases
Step 4: Select a database and it displays the list of tables present in the database
Step 5: Select the table from the list of tables
Step 6: Select the option Operations at the top of the page
Step 7: Go to Table option and Select Storage Engine as InnoDB
Step 8: Click Go button to change the storage engine
Step 9: Now it displays a successful message
Step 10: Finally, the table was updated and changed in the list
Step 1 Login to cPanel.
Step 2 Go to Database Section and select phpMyAdmin.
Go to Database section and select phpMyAdmin
Step 3 On the left pane of the phpMyAdmin Main Page, it displays the list of available Databases.
Displays the list of Database on left pane
Step 4 Select a database and it displays the list of tables present in the database.
Select the Database and displays the list of tables
Step 5 Select the table from the list of tables.
Select the table from the list of tables
Step 6 Select the option Operations at the top of the page.
Select Operation option at top of the page
Step 7 Go to Table option and Select Storage Engine as InnoDB.
Go to Table option and Select Storage Engine as InnoDB
Step 8 Click Go button to change the storage engine.
Click Go button to change the storage engine
Step 9 A successful message will be displayed.
Step 10 Table will be updated in the database and changed in the list.
