MySQL：mysqldump 异常记录

记录下异常问题

1、Couldn’t execute 'SELECT COLUMN_NAME

mysql版本：Ver 8.0.22 for Win64 on x86_64

mysqldump导出时报如下错误

导出语句：

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqldump.exe -h127.0.0.1 -uroot -p123456 -P3306 test > E:\xiaobai\test\test.sql

报错：

mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')  FROM information_schema.COLUMN_STATISTICS  WHERE SCHEMA_NAME

解决方法：添加 –column-statistics=0 参数

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqldump.exe --column-statistics=0 -h127.0.0.1 -uroot -p123456 -P3306 test > E:\xiaobai\test\test.sql