I'm trying to install Moodle 3.9 in a LAMP environment (dedicated server), and I'm running into an issue. When the installation process checks for the environment configuration, I get these 2 errors that are preventing the installation from continuing:
Your database uses Antelope as the file format. Full UTF-8 support in MySQL and MariaDB requires the Barracuda file format. Please switch to the Barracuda file format. See the documentation MySQL full unicode support for details.
For full support of UTF-8 both MySQL and MariaDB require you to change your MySQL setting 'innodb_large_prefix' to 'ON'. See the documentation for further details.
I've read that Moodle is now requiring Barracuda instead of Antelope, but I've also read some conflicting information, where it's more a recommendation and not a requirement. I've followed the suggestion made in this thread (changing the database collation to utf8_general_ci) but I still get the same error.
One solution would be to change the file system at a MySQL configuration level, but the problem is that I have many other databases in this same server and I've read that changing the file system can potentially break them.
Another interesting thing is that I actually have another Moodle 3.7 site in this same server (which was an originally installed from version 3.4 and upgraded to 3.7) and I did not have this issue when installing or upgrading, and the site works perfectly fine.
Any way I can force the installation with Antelope? Or if there's no other way around having to use Barracuda, any way I can force only this database to use Barracuda and not the whole MySQL installation?