记录下异常问题
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
版权声明：本文为slaron原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。