首页 > 数据库 >mysqldump throws: Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

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

时间:2022-09-06 20:56:19浏览次数:72  
标签:information STATISTICS COLUMN db mysqldump schema

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

 

标签:information,STATISTICS,COLUMN,db,mysqldump,schema
From: https://www.cnblogs.com/xzlive/p/16663268.html

相关文章