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