Migration from MyISAM to InnoDB

Admin tools

(Additional tools may be found elsewhere in the admin settings)

This page only applies to administrators using Moodle with a MySQL database as it's about migrating the MySQL storage engine.


Contents


Why migrate to InnoDB?

Starting from Moodle 2.9 MyISAM is no longer supported. InnoDB works more robustly, performs better with big sites and allows better data integrity features (transactions).


MySQL Configuration

Before attempting to change the table type, you should:


Various Methods described in Moodle forums (choose one)


See also

Using Moodle forum discussions: