AI智能
改变未来

问题记录:mysqldump 出现 Unknown table ‘column_statistics‘ in information_schema


mysqldump 出现如下问题

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

解决办法 增加参数 –column-statistics=0

mysqldump -uroot -p -P53306 test-db --column-statistics=0 > test-db.sql.gz
赞(0) 打赏
未经允许不得转载:爱站程序员基地 » 问题记录:mysqldump 出现 Unknown table ‘column_statistics‘ in information_schema