If you need to change "type" of a table from MyISAM to InnoDB, you can do this via phpMyAdmin on cPanel. To do this, simply follow these steps:
- Log in to your cPanel account.
- Navigate to the databases section and click on phpMyAdmin or search for phpMyAdmin in the search bar.
- Select the required database from the left-hand menu.
- From the list of tables, click on the required table and choose the Operations option from the top menu.
- Navigate to the Table option section and choose InnoDB from the Storage Engine dropdown menu.
- Click on Go on the bottom right-hand side.
That's it! You have now changed the table type from MyISAM to InnoDB.
Please note, we always recommend taking a backup of your database before making any changes in case of any errors or conflicts.