How to change the MySQL database table engine to InnoDB

Last modified: February 25, 2020
You are here:
Estimated reading time: < 1 min

Change the MySQL database table engine to InnoDB

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

Was this article helpful?
Dislike 0
Views: 23