Mysqldump error: Couldn’t execute ‘SELECT COLUMN_NAME
Correcting the error mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT (HISTOGRAM,’ $. “number-of-buckets-specified” ‘)
Error
May occur when exporting a database to DataGrip or when working in other programs with PostgreSQL databases.
mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT (HISTOGRAM,’ $. “number-of-buckets-specified” ‘) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME =’ bd_name ‘AND TABLE_NAME.net =’ table_; ploshad: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
Decision
Add attribute when exporting column-statistics = 0:
“bd_name” –result-file=“/Users/Dream/Downloads/ {data_source }- {timestamp }-dump.sql” –column-statistics=0