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.