mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."n

mysqldump报错如下：

mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'tongdun_feature_offline_new' AND TABLE_NAME = 'tongdun_feature_offline';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)
 

 

解决方案

查看mysql连接客户端

[root@test02 mysql56]# rpm -qa|grep mysql
mysql-community-common-8.0.13-1.el7.x86_64
mysql-community-libs-compat-8.0.13-1.el7.x86_64
mysql-community-libs-8.0.13-1.el7.x86_64
mysql80-community-release-el7-1.noarch
mysql-community-client-8.0.13-1.el7.x86_64
 

而mysql安装的是源码包5.6.16，不匹配

 

使用原来的源码包的客户端即可导出

 

./bin/mysqldump -uroot -ppassword  --databases test01  >/backup/test01.sql