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
