Skip to main content

cPanel accounts migrated from a server with MySQL 5.6 to 5.7 will fail due to "show_compatibility_56"

Jeremy Maldonado
  • Updated

Symptoms

 

In some cases, it is possible that migrating accounts from a server with MySQL 5.6 to a server with MySQL 5.7 will fail. This will be reported in the transfer log.

 

Warning: The system failed to reinstall the MySQL database  “testing_database” as 
“testing_database” because of an error: The MySQL  server reported an 
error (The 'INFORMATION_SCHEMA.SESSION_VARIABLES'  feature is disabled; 
see the documentation for 'show_compatibility_56')  in response to this 
request: /*!50112 SELECT COUNT(*) INTO  @is_rocksdb_supported FROM 
INFORMATION_SCHEMA.SESSION_VARIABLES WHERE  
VARIABLE_NAME='rocksdb_bulk_load' */ at  /usr/local/cpanel/Whostmgr
/Transfers/SystemsBase/MysqlBase.pm line 323,  <$_[...]> line 17.

 

Description 

 

As mentioned in the log report above, this is caused by a deprecated function in MySQL 5.6 that is no longer available in MySQL 5.7. This can be circumvented by enabling the following option in MySQL: show_compatibility_56

 

The official documentation on this function is mentioned here.

 

Workaround

 

Edit the MySQL configuration file, /etc/my.cnf and add the following value in the [mysqld] section:

show_compatibility_56=ON

 

Then, restart MySQL using the command here:

/scripts/restartsrv_mysql

Related articles