This article describes the steps to change the storage engine of a MySQL database table. If you want to change the storage engine of the database table demo from InnoDB to MyISAM, you can implement any of the two following methods –
Method 1
1. Log in to phpMyAdmin.
2. Navigate to the database table whose storage engine you wish to change.
3. Click on the SQL tab, paste the following query in the query box, and click on the Go button –
ALTER TABLE demo ENGINE = MyISAM;
Method 2
1. Log in to phpMyAdmin.
2. Navigate to the database table whose storage engine you wish to change.
3. Click on the Operations tab; under the Table option, you will find a Storage Engine drop-down.
4. Select the storage engine of your choice from the Storage Engine drop-down and click on the Go button.
→ Facing a MySQL error Plugin 'InnoDB' registration as a STORAGE ENGINE failed?
Please refer to Fix MySQL InnoDB storage engine failed for more details.
