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

AWS RDS_MYSQL 8.0 执行mysqldump报以下错误

?

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

 

具体

?

1 2 3 4 5 6

$> 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)

 

解决方式：

?

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