Mysql innodb_file_type error

Mysql innodb_file_type error

by Cham Pereira -
Number of replies: 3

Hi all,

I started installing moodle on my vm. I have installed cent os  8.1.1 and mysql version 8.0.17. 

when I added following lines to the my.cnf file. It gives me a unknown variable error. 

innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix

Without the above lines mysql works fine. Can you kindly help me to proceed

Average of ratings: -
In reply to Cham Pereira

Re: Mysql innodb_file_type error

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
innodb_large_prefix = 1

??
Average of ratings: -
In reply to Howard Miller

Re: Mysql innodb_file_type error

by Cham Pereira -
Actually error was with the first line
innodb_file_format = Barracuda
I did comment the other 2 lines.

error was unknown variable 'innodb_file_format = Barracuda'
???
Average of ratings: -
In reply to Cham Pereira

Re: Mysql innodb_file_type error

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
innodb_file_format is deprecated in MySQL 8. Someone needs to update MySQL for MySQL 8.

I *think* those settings are no longer needed at all in MySQL 8. They are the new default.
Average of ratings: -