cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Converting Moodle Database from InnoDB Antelope to Barracuda

Hi there,

Can someone from GoDaddy support help me?

I need to change my Moodle database from InnoDB Antelope to Barracuda.

When I run the commands listed below in phpMyAdmin, I get the following error:
SQL query:
SET GLOBAL innodb_file_per_table =1;
MySQL said: Documentation
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Since I do not have SUPER privileges, can you run the following commands for me?

USE my_database_name;
SET SESSION sql_mode=STRICT_ALL_TABLES;
SET GLOBAL innodb_file_per_table=1;
SET GLOBAL innodb_file_format=Barracuda;
ALTER TABLE mdl_data ROW_FORMAT=Compressed;
ALTER TABLE mdl_data_fields ROW_FORMAT=Compressed;
ALTER TABLE mdl_enrol_paypal ROW_FORMAT=Compressed;
ALTER TABLE mdl_lti ROW_FORMAT=Compressed;
ALTER TABLE mdl_user ROW_FORMAT=Compressed;
ALTER TABLE mdl_user_info_field ROW_FORMAT=Compressed;

2 REPLIES 2
Moderator
Moderator

Re: Converting Moodle Database from InnoDB Antelope to Barracuda

Hello @ozanvarli, if you're using a shared hosting plan you would not have access to the Superuser options.  You would need either a VPS or Dedicated Server plan for that level of access.  

 

MPC

New

Re: Converting Moodle Database from InnoDB Antelope to Barracuda

Same problem for me... a down Kudos to godaddy.