[Solved] Mistake 3167 (Hy000) The 'Information_Schema.Global_Variables' Characteristic Is Disabled Run Into The Documentation For 'Show_Compatibility_56'

You mightiness leave of absence the fault below during MySQL database restore to 5.7 in addition to the backup taken from MySQL 5.6 server.

ERROR 3167 (HY000): The 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' characteristic is disabled; encounter the documentation for 'show_compatibility_56'

To solve this consequence allow follow the steps below:

Step 1:- Check MySQL compatibility

By default MySQL 5.7 doesn't allow to restore 5.6 databases. For this, We require to enable MySQL 5.6 compatibility. Let's banking concern lucifer this using ascendence below:

mysql> SHOW VARIABLES LIKE "%compatibility%"; +-----------------------+-------+ | Variable_name         | Value | +-----------------------+-------+ | show_compatibility_56 | Off    | +-----------------------+-------+ ane row inwards fix (0.00 sec) 

That agency yours MySQL 5.7 server doesn't conduct maintain enabled 5.6 database compatibility.

Step 2:- Enable MySQL 5.6 compatibility

Let's enable MySQL 5.6 compatibility in addition to hence nosotros tin restore the database to MySQL 5.7 server.

mysql> SET GLOBAL show_compatibility_56 = ON;

Now MySQL5.6 compatibility has been enabled in addition to you lot tin restore a database that backed upwards from MySQL 5.6 Server.

Step 3:-  Let's validate compatibility status:

Let's hitting ascendence below to banking concern lucifer condition whether it's enabled or not.

mysql> SHOW VARIABLES LIKE "%compatibility%"; +-----------------------+-------+ | Variable_name         | Value | +-----------------------+-------+ | show_compatibility_56 | ON| +-----------------------+-------+ ane row inwards fix (0.00 sec)

Compatibility has been enabled successfully. Now, you lot tin restore a database backup taken from MySQL5.6 server.

Sumber https://linuxhowtoguide.blogspot.com/