Change MySQL to InnoDB (split from Don't allow students to download videos)

Change MySQL to InnoDB (split from Don't allow students to download videos)

by Ricardo Adrian -
Number of replies: 2

I'm trying to update to 3.0, since my version is 2.6 but it says that I have to change de MySql to InnoDB before upgrading... it says:

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.

    I'm new to this and don't even know where to check if the InnoDB is enabled... I don't know how to enter the MySql console... it should be done from the server, or from the moodle?...


(Edited by Mary Cooch - original submission Friday, 18 May 2018, 4:18 PM)

Average of ratings: -
In reply to Ricardo Adrian

Re: Change MySQL to InnoDB (split from Don't allow students to download videos)

by James Steerpike -

If you are on a shared host, you will probably find the host controls the database settings. In that case, you must get them to do it. Not all shared hosting sites will change,

Average of ratings: -