Difference between revisions of "Storage Engine - How to change in MySQL"
From Hostek.com Wiki
(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...") |
m (Briana moved page MySQL Change Storage Engine to Storage Engine - How to change in MySQL without leaving a redirect) |
(No difference)
|
Latest revision as of 15:38, 26 November 2013
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.