How To Change MySQL Database Storage Engine MyISAM or InnoDB

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

How To Change MySQL Database Storage Engine MyISAM or InnoDB

Postby 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_myisam_mysql.jpg
InnoDB or MyISAM
innodb_myisam_mysql.jpg (10.26 KiB) Viewed 2171 times

Whatever your need, switching is possible anytime, especially via phpMyAdmin on your cPanel interface. Let me show you how to do this.

Steps:

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_users ENGINE=MyISAM;
ALTER TABLE wp_comments ENGINE=InnoDB;

Click Submit!

Success!
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

Postby HowTutor » 22 Feb 2015, 17:07

Please share.


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

  • Similar Topics
    Comments
    Views
    Last post

Return to “The Internet, Web”

Online now

Users browsing this section: No registered users and 1 guest