How to change MySQL database table engine to InnoDB

JE Gan

Modified on: Thu, 10 Jul, 2025 at 5:00 PM

1. Access PHPMyAdmin. (You can locate your PHPMyAdmin URL within your cPanel.

2. Select the database from the left-hand panel.

3. Click on the SQL tab.

4. Execute the following query:

ALTER TABLE TableName ENGINE = InnoDB;

Note:
TableName: the designation of the database table

5. Click the Go button.

6. Process completed!