知乎专栏 |
问题出现在 MySQL 8.0 备份 MySQL 5.7 数据库时。
mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'testra' AND TABLE_NAME = 'branch';': Unknown table 'column_statistics' in information_schema (1109)
解决办法,使用 --column-statistics=0 选项
mysqldump -hdb.netkiller.cn -uroot -ptest neo --column-statistics=0