How to solve mysql_full_unicode_support#File_format moodle installation error

No Comments

Have you encountered mysql_full_unicode_support#File_format and mysql_full_unicode_support#Large_prefix during installation of Moodle on localhost or a shared host?

Here is a short list of instructions on how to solve it

  1. Make sure you have created an empty Moodle database(Moodle does this automatically during installation)
  2. Open open the table then click on SQL tab on phpmyadmin
  3. Input and run the following SQL statements
set global innodb_file_format = `BARRACUDA`;
set global innodb_large_prefix = `ON`
Tags: , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

How AI will revolutionize eLearning
3 best WordPress LMS plugins (Learning and Development)
You might also like