Storage Engine - How to change in MySQL

From Hostek.com Wiki
Revision as of 05:29, 26 November 2013 by Carlb (Talk | contribs) (Created page with "==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: <p...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.

Retrieved from "https://wiki.hostek.com/index.php?title=Storage_Engine_-_How_to_change_in_MySQL&oldid=1812"