Storage Engine - How to change in MySQL

From Wiki
Jump to: navigation, search

Change MySQL Storage Engine

To change the MySQL storage engine for a particular table you can run the following query in PHPmyAdmin or the MySQL Client of your choice:

ALTER TABLE exampleTable ENGINE = innodb

NOTE: You will need to make sure and change "exampleTable" to the actual table name you want to change.