Change table type from MyISAM to InnoDB in phpMyAdmin

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:

  1. Log in to your cPanel account.
  2. Navigate to the databases section and click on phpMyAdmin or search for phpMyAdmin in the search bar.
  3. Select the required database from the left-hand menu.
  4. From the list of tables, click on the required table and choose the Operations option from the top menu.
  5. Navigate to the Table option section and choose InnoDB from the Storage Engine dropdown menu.
  6. 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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What is the PHP memory limit?

The default PHP memory limit is 128MB on all cPanel accounts. This can be increased by using the...

How do I change PHP version on cPanel?

To change the PHP version on cPanel, you need to navigate to Select PHP Version and choose the...

How do I turn on PHP error messages on cPanel?

If you have ever come across an error on your website you will likely have been left scratching...

How to view your website’s PHP version?

The easiest way to create your phpinfo.php file is to use File Manager on cPanel. To do this,...

How do I change my PHP version on cPanel?

If you need to change your PHP version, this can be done easily through your cPanel account by...