Today 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.
Great! Straight to the point, just what I needed.
Thanks for sharing 🙂
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!
As Steve said, it straight to the point.
Thanks Scommerce