-->

Tuesday, July 21, 2020

[Solved] Unknown table 'COLUMN_STATISTICS' in information_schema

Error:-
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'uadmin' AND TABLE_NAME = 'uauth_group';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109) 
 
Resolution:-I
t is due to a new flag that has been enabled by default in the mysqldump 8. you will have to disable it by adding the column-statistics=0. After which the command would be become something like
 mysqldump --column-statistics=0 --host=<server> --user=<user> --password=<password