Posts

Showing posts from July, 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

Understanding the Apigateway and its advantages

Image