Convert to Barracuda

Convert to Barracuda

Robert Hegestedt-mit -
Antal besvarelser: 3

Hi,

I try to install Moodle 3.2.2 on a Xampp for windows 7.1.1, using php version 7.1.1.

I get to the part where it checks server settings and I get the following message:

Your database has tables using Antelope as the file format. Full UTF-8 support in MySQL and MariaDB requires the Barracuda file format. Please convert the tables to the Barracuda file format. See the documentation Administration via command line for details of a tool for converting InnoDB tables to Barracuda.


I followed the following tutorial but couldn't get it to work, I made the changes in my.ini form xampp control panel. Is this the right file?

https://docs.moodle.org/32/en/MySQL_full_unicode_support#File_format


Gennemsnitsbedømmelse: -
I svar til Robert Hegestedt

Re: Convert to Barracuda

Deepak Gour-mit -

Hi Robert

I hope you put code in my.ini only below code.


[client]
default-character-set = utf8mb4

[mysqld]
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-character-set-client-handshake

[mysql]
default-character-set = utf8mb4
Restart your server.

I svar til Deepak Gour

Re: Convert to Barracuda

Howard Miller-mit -
Core developers-ip assinga Documentation writers-ip assinga Particularly helpful Moodlers-ip assinga Peer reviewers-ip assinga Plugin developers-ip assinga

With my moderator hat on.... I'm not sure it's helpful to resurrect several month old threads. Especially as the OP reported that the problem was resolved at the time.