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)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay