Note: You are currently viewing documentation for Moodle 2.2. Up-to-date documentation for the latest stable version is available here: Migration from MyISAM to InnoDB.

Migration from MyISAM to InnoDB: Difference between revisions

From MoodleDocs
Line 9: Line 9:


== Various Methods described in Moodle Forums==
== Various Methods described in Moodle Forums==
* run the innodb script as a webpage http://www.mymoodle.com/admin/innodb.php  (there might be timeout issues on large databases and it only works with mysql)
* use the CLI script in admin/cli/mysql_engine.php  (requires access to shell, mysql only, and the config.php must only have one moodle instance)  
* use the CLI script in admin/cli/mysql_engine.php  (requires access to shell, mysql only, and the config.php must only have one moodle instance)  
* use PHPMyAdmin entering Structure view of a table and clicking Operations tab. Look for Storage Engine parameter. This is a tedious task due to the number of tables [http://moodle.org/mod/forum/discuss.php?d=162002]
* use PHPMyAdmin entering Structure view of a table and clicking Operations tab. Look for Storage Engine parameter. This is a tedious task due to the number of tables [http://moodle.org/mod/forum/discuss.php?d=162002]


[[fr:admin/innodb]]
[[fr:admin/innodb]]

Revision as of 00:06, 30 November 2010


See Documentation for migration from MyISAM to InnoDB for the current discussion which prompted the creation of this page. --Frank Ralf 11:41, 24 November 2010 (UTC)

MySQL Configuration

Before attempting to change the table type, you should:

  • check InnoDB is enabled. Log in to MySQL and run the command SHOW ENGINES. Make sure that support for InnoDB shows either "YES" or "DEFAULT".
  • set innodb_file_per_table if required. This setting can be useful for large installations, but it only affects newly created tables and can't be applied retrospectively.

Various Methods described in Moodle Forums

  • run the innodb script as a webpage http://www.mymoodle.com/admin/innodb.php (there might be timeout issues on large databases and it only works with mysql)
  • use the CLI script in admin/cli/mysql_engine.php (requires access to shell, mysql only, and the config.php must only have one moodle instance)
  • use PHPMyAdmin entering Structure view of a table and clicking Operations tab. Look for Storage Engine parameter. This is a tedious task due to the number of tables [1]