mysqldump: Couldn‘t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.“*

使用mysqldump时，导出异常

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

原因： 使用的mysqldump版本高于mysql数据库的版本

mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.7.14    |
+-----------+
1 row in set (0.00 sec)

MacBook-Pro:bin root# mysqldump  --version
mysqldump  Ver 8.0.23 for osx10.16 on x86_64 (Homebrew)

解决办法：导出时加入参数 --column-statistics=0

mysqldump -uroot -p123 -S /tmp/mysql14.sock dbtest14   --column-statistics=0 > /usr/local/mysql_14/mysql-5.7.14-osx10.11-x86_64/dbtest14bak.sql
mysqldump: [Warning] Using a password on the command line interface can be insecure.