How to convert from MyISAM to InnoDB using phpMyAdmin?
When Installed Moodle 2.x, following message are showing up in the font page of Moodle.
Database tables are using MyISAM database engine, it is recommended to use ACID compliant engine with full transaction support such as InnoDB.
When searched for “convert MyISAM to InnoDB using phpMyAdmin” in Google, I got many responses and I also found a link from Moodle which didn’t help me at all.
I finally found this article from http://richardcummings.info/convert-myisam-to-innodb-using-phpmyadmin/comment-page-1 and the instructions says
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!
I couldn’t find the Drop Down box next to “ Storage Engine” After playing around, I came to know where to find drop down box
1. Go to phpMyAdmin
2. Select your database and click on Structure icon
3. This is what you will see when you click on structure icon
4. Now click on Operations tab and now you will see Storage Engine and if you click on the drop down, you can see InnoDB. Select InnoDB and click GO
5. Now if you go back to your database table, you can see type is changed to InnoDB
Using this method you can easily convert your database from MyISAM to InnoDB using phpMyAdmin.
Many Thanks to Richard Cummings