MySQL – Antelope and Barracuda – Moodle

If you are running Moodle LMS or running MySQL, your application and your MySQL database may need to be converted to Barracuda instead of Antelope.  The default InnoDB table format (Antelope) may have bugs and many administrators recommend that you change the table to Barracuda.

In Moodle, on the server, change to the PHP directory.  Run the command –

php c:\inetpub\wwwroot\yourfolder\admin\cli\mysql_compressed_rows.php -l

This will identify the tables that need to be fixed.

Now run the command again with the -f switch.

php c:\inetpub\wwwroot\yourfolder\admin\cli\mysql_compressed_rows.php -f

More information –Link



About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Technology. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s