Migration from MyISAM to InnoDB: Difference between revisions

Revision as of 00:06, 30 November 2010

This article is a stub. Please help improve Moodle Docs by editing it and adding some content.

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)

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.

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]

@@ Line 9: / Line 9: @@
 == 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 [http://moodle.org/mod/forum/discuss.php?d=162002]
 [[fr:admin/innodb]]