Error when change the default file format to Barracuda

Error when change the default file format to Barracuda

by saleh refaai -
Number of replies: 1

I am trying to install Moodle on my local machine. I am using Ubunto server on VirtualBox VM machine. I followed the steps as moodle mentioned in the documentation. When I reached the part where I have to add this code (innodb_file_format = Barracuda), it gives me this error when I try to restart MySQL Server 


 But when I comment the code of  (innodb_file_format = Barracuda) in the file, it works. What the solution could be?   
The code of the file:

Average of ratings: -
In reply to saleh refaai

Re: Error when change the default file format to Barracuda

by Leon Stringer -
Picture of Core developers Picture of Particularly helpful Moodlers

What version of MySQL or MariaDB do you have? That documentation says:

For MySQL Ver 8.0, the three settings below [... innodb_file_format = Barracuda ] are not needed.

and

If you use newer versions of MariaDB in Ubuntu 20.04 these changes in config file would arise and error (mysql unknown variable 'innodb_file_format=barracuda'), so comment or don't make these changes

so you probably don't need any of these settings. You can run SHOW GLOBAL VARIABLES WHERE variable_name IN ('innodb_file_format', 'innodb_large_prefix', 'innodb_file_per_table') to see if MySQL/MariaDB is correctly configured, the results should be as shown here.