Antelope to Baracuda

Antelope to Baracuda

by Albert Ramsbottom -
Number of replies: 2

I have run the following CMD

sudo php admin/cli/mysql_compressed_rows.php --fix

And get the following error:

Cannot enable GLOBAL innodb_file_per_table setting, use --showsql option and execute the statements manually.Default exception handler: Error writing to database Debug: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

SET GLOBAL innodb_file_per_table=1

[array (

)]

Error code: dmlwriteexception

* line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown

* line 974 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()

* line 140 of /admin/cli/mysql_compressed_rows.php: call to mysqli_native_moodle_database->execute()


!!! Error writing to database !!!

Any ideas

Albert

Average of ratings: -
In reply to Albert Ramsbottom

Re: Antelope to Baracuda

by Paul Holden -
Picture of Core developers Picture of Moodle HQ Picture of Moodle Workplace team Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Testers
  1. Run the CLI tool with --showsql argument
  2. Login to your database administration tool with a privileged account
  3. Copy and execute SQL produced from step 1

(Just as the error message suggests... wink)

Average of ratings: Useful (1)