DEV Community

Cover image for How to solve "Unknown table 'COLUMN_STATISTICS'"
Sergio Peris
Sergio Peris

Posted on • Edited on • Originally published at sertxu.dev

How to solve "Unknown table 'COLUMN_STATISTICS'"

MySQL Workbench is very useful when managing both MySQL and MariaDB databases, but it's possible to encounter the following error.

Unknown table 'COLUMN_STATISTICS' in information_schema (1109)
Enter fullscreen mode Exit fullscreen mode

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

We are looking for the line containing skip_column_statistics = True as we should comment out the subsequent condition.

Once you restart the program and it should work correctly.

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more