Convert MyISAM to INNODB using phpMyAdmin for Moodle

May 11, 2011 — 3 Comments

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.

Moodle Error : Database tables are using MyISAM database engine

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

convert MyISAM to InnoDB using phpMyAdmin

 

3. This is what you will see when you click on structure icon

convert MyISAM to InnoDB for Moodle

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

image

5. Now if you go back to your database table, you can see type is changed to InnoDB

converted MyISAM to InnoDB using phpMyAdmin Storage Engine

 

Using this method you can easily  convert your database from MyISAM to InnoDB using phpMyAdmin. 

Many Thanks to Richard Cummings

3 responses to Convert MyISAM to INNODB using phpMyAdmin for Moodle

  1. 

    I found this solution in http://kvz.io/blog/2010/04/27/convert-all-tables-to-innodb-in-one-go/
    DATABASENAME=”kvz”

    for t in `echo “show tables” | mysql –batch –skip-column-names $DATABASENAME`; do mysql $DATABASENAME -e “ALTER TABLE \`$t\` ENGINE = InnoDB;”; done

Trackbacks and Pingbacks:

  1. Convert MySQL Database from MyISAM to INNODB | Virtualize SharePoint and SharePoint Virtualization - May 13, 2011

    [...] previous post I mention that you can change the MyISAM database engine to InnoDB using phpMyAdmin : Convert MyISAM to INNODB using phpMyAdmin for Moodle but it will take some time to change each table one by [...]

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s