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)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Engage with a sea of insights in this enlightening article, highly esteemed within the encouraging DEV Community. Programmers of every skill level are invited to participate and enrich our shared knowledge.

A simple "thank you" can uplift someone's spirits. Express your appreciation in the comments section!

On DEV, sharing knowledge smooths our journey and strengthens our community bonds. Found this useful? A brief thank you to the author can mean a lot.

Okay