Tutorials, guides and know hows useful on the World Wide Web: social networking, web design, programming, domains, hosting and more.
Post Reply

How To Change MySQL Database Storage Engine MyISAM or InnoDB

Post by HowTutor » 08 Dec 2014, 20:16

This tutorial will detail how to change a MySQL database table storage engine between MyISAM or InnoDB. The war between InnoDB and MyISAM has been on for a long time, with each engine winning in different contexts and conditions. While one is good for transactions, other may be preferable in other scenarios or needs.
InnoDB or MyISAM
innodb_myisam_mysql.jpg (10.26 KiB) Viewed 3177 times
Whatever your need, switching is possible anytime, especially via phpMyAdmin on your cPanel interface. Let me show you how to do this.


1. Log in to your cPanel interface with your admin user name and password.
2. Locate the phpMyAdmin icon and select it. This opens a new interface in another window or tab.
3. Select the DB (Database) you want to work with.
4. Select SQL Query (after Structure) on the upper tab. This opens a small dialogue box where you run SQL Queries in phpMyAdmin.
5. Type in the command queries to convert of change your selected tables between MyISAM or InnoDB in the following format:

Code: Select all

ALTER TABLE tableprefix_tablename ENGINE=MyEngine;
For example:

Code: Select all

ALTER TABLE wp_comments ENGINE=InnoDB;
Click Submit!

In the above example, I have successfully changed the engine of table wp_users to MyISAM and that of wp_comments to InnoDB.

And... That's all! Engines changed!

Please share this tutorial...


Re: How To Change MySQL Database Storage Engine MyISAM or In

Post by HowTutor » 22 Feb 2015, 17:07

Please share.

Last bumped by HowTutor on 22 Feb 2015, 17:07.

Post Reply
  • Similar Topics
    Last post