How to change the MySQL database table engine to InnoDB

JE Gan

Modified on: Mon, 24 Feb, 2020 at 2:57 PM

1) Log into PHPMyAdmin. (You can get your PHPMyAdmin URL inside your cPanel / HELM)

2) Select the database

3) Click on the SQL Tab

4) Run the query as below.

ALTER TABLE TableName ENGINE = InnoDB;

Note:
TableName: database table name

5) Click Go button

6) Done