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

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *