mysqldump throws: Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

本文主要是介绍mysqldump throws: Unknown table 'COLUMN_STATISTICS' in information_schema (1109)，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

AWS RDS_MYSQL 8.0 执行mysqldump报以下错误

mysqldump throws: Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

具体

$> mysqldump --single-transaction --host host -u user -p db > db.sql
mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM,
'$."number-of-buckets-specified"') FROM
information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'db' AND
TABLE_NAME = 'Absence';':
Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

解决方式：

$> mysqldump --column-statistics=0 --host host -u user -p db > db.sql

这篇关于mysqldump throws: Unknown table 'COLUMN_STATISTICS' in information_schema (1109)的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！