mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME,

发布于 作者:

今天使用 mysqldump 导出阿里云虚拟主机的数据库，出现了错误

mysqldump
mysqldump

mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS
WHERE SCHEMA_NAME = 'bdmxxxxx_db' AND TABLE_NAME = 'wp_actionscheduler_actions';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

解决的方法 mysqldump --column-statistics=0

添加的上 --column-statistics=0

或者

[mysqldump]
column-statistics=0