How to Change the Storage Engine of a MySQL Database Table? Print

  • 4

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;

 

SQL Query Window

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 drop-down called Storage Engine.

  4. Select the storage engine of your choice from the Storage Engine drop-down and click on the Go button.


Table Options

 

 


→ Facing a MySQL error Plugin 'InnoDB' registration as a STORAGE ENGINE failed?

Please refer to
Fix MySQL InnoDB storage engine failed for more details.

 


Was this answer helpful?

« Back

chat