I am running:
Moodle 3.1.9 on Centos 7.
When I go to site 10.10.20.97/moodle. I get to the server checks and run into 2 issues under other checks. it says see documentation https://docs.moodle.org/34/en/Administration_via_command_line
I ran commands and results are listed below after commands
mysql_full_unicode_support#File_format this test must pass
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.
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.
Check the Moodle site for documentation:
To view tables requiring conversion, use the list option:
$ php admin/cli/mysql_compressed_rows.php –list Nothing happens, no list is generated, just right back to prompt
Here is an example output:
mdl_data Compact (needs fixing)
mdl_data_fields Compact (needs fixing)
mdl_enrol_paypal Compact (needs fixing)
To proceed with the conversion, run the command using the fix option:
$ php admin/cli/mysql_compressed_rows.php –fix Says no changes necessary when I run command.
Successful table conversion will be reported in the output, for example:
mdl_data ... Compressed
mdl_data_fields ... Compressed
mdl_enrol_paypal ... Compressed
Please note that the commands must be executed on your moodle directory. Once tables are fixed, the warning message will no longer be displayed.
If you get errors due to having insufficient privileges to run these commands (this is quite likely) then the easiest solution is to generate the required SQL commands using,
$ php admin/cli/mysql_compressed_rows.php --showsql
You can then copy the generated SQL into your mysql client running as the 'root' user.