Unknown system variable 'show_compatibility_56

user_5262101 0
Viewed 425

I have created a docker image and installed and got MySQL up and running. I'm trying to restore a dump file and I'm getting

ERROR 1193 (HY000) at line 3184: Unknown system variable 'show_compatibility_56'

I tried to set the variable in the Workbench but I get variable not found.

Can someone tell me what I need to do to get a DB Dump to restore?

docker mysql
1 Answers

If you are using MySQL 8+ the show_compatibility_56 system variable is removed

Beyond MySQL 5.7

In a MySQL 8.0, the INFORMATION_SCHEMA variable tables and the show_compatibility_56 system variable are removed, and output from the SHOW statements is always based on the underlying Performance Schema tables.

Applications that have been revised to work in MySQL 5.7 when show_compatibility_56=OFF should work without further changes, except that it is not possible to test or set show_compatibility_56 because it does not exist.

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html

user_164619520
Related