This is a technical post on how to convert from MyISAM to InnoDB using phpMyAdmin.
Yesterday, I was using phpMyAdmin to set up database tables in MySQL. The solution that I was implementing called for me to use foreign keys to relate the tables to one another. Well, foreign keys require the use of the InnoDB search engine instead of the default MyISAM.
Often, within phyMyAdmin, I type my SQL syntax directly using the SQL tab within phpMyAdmin (which in this case would be “ALTER TABLE tablename ENGINE=InnoDB;”). However, a customer recently asked me how to convert the tables from MyISAM to INNODB using the phpMyAdmin graphical interface so I thought I would give that a go.
When I searched for “convert MyISAM to InnoDB using phpMyAdmin” in Google, I received a bunch of responses that were wrong…or maybe I should just say outdated. (I think Google should update their algorithm for technical queries to default to recent, rather than older, material.) These outdated posts talked about the need to modify an admin config file and suggested a process that seemed to take a while. Not so.
You can convert from MyISAM to InnoDB in phpMyAdmin with just a few clicks. To convert your data tables from MyISAM to InnoDB in phpMyAdmin, you will select the table, click the “Operations” tab, and then choose InnoDB from the drop down box next to the “Storage Engine” type. Click “Go” and you are done!
NOTE: Initially, my conversion was unsuccessfully because I received a message that said The Used Table Type Doesn’t Support FULLTEXT Indexes. If you receive a similar message, follow that link to solve it!
Hope this helps. Enjoy the day,