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.
