How to solve "Unknown table 'COLUMN_STATISTICS'"

How to solve "Unknown table 'COLUMN_STATISTICS'"

12 April 2021
175
Tips Linux Server

The MySQL Workbench program is very useful when managing both MySQL and MariaDB databases, but it is possible that we have encountered the following error.

Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

To fix this error we must modify the MySQL Workbench file wb_admin_export.py.

We look for the line containing "skip_column_statistics = True" and comment out the subsequent condition.

Restart the program and it should work correctly.