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

Migration from MyISAM to InnoDB

From MoodleDocs
Revision as of 09:44, 29 November 2010 by Séverin Terrier (talk | contribs) (French link)

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)

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.
Retrieved from "https://docs.moodle.org/39/en/index.php?title=Migration_from_MyISAM_to_InnoDB&oldid=78442"
Powered by MediaWiki