mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)

Magento throws unknown tableToday we were trying to backup localhost database using mysqldump command line but we were keep on getting the following error -:

Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

After investigation we spotted this was happening because of a new flag that is enabled by default in mysqldump 8. You can disable it by simply adding –column-statistics=0 as shown below.

mysqldump --column-statistics=0 -h 127.0.0.1 -P 3306 -u root -p database_name > database_name.sql

That’s it, Hope this article helped you in some way. Please leave us your comment and let us know what do you think? Thanks.

3 thoughts on “mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)

    1. Thanks Steve for the feedback, we tend to come straight to the point instead of beating around the bush, lol 🙂

      We are glad we could help you!

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.