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)

Advertise with us

We can connect you to one of the world’s largest audiences of high net worth, highly educated & international professionals.

My Portfolio

I have been involved in the delevelopment or various applications and websites