mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“number-of-buckets-specified”’) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘xxx’ AND TABLE_NAME = ‘xxx’;’: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
如何解决:
方法一:
mysqldump -u 账号 -p密码 -h主机地址 数据库名称 --column-statistics=0 --set-gtid-purged=OFF > /home/backup.sql
方法二:
使用对应版本的mysqldump进行备份数据