mysqldump 出成SQL文件报错

原语句1

mysqldump -uroot -p lsj2021_practice > D:/lsj2021_practice.sql

报错信息1

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

原因分析：新版的mysqldump默认启用了一个新标志，通过- -column-statistics=0来禁用他

修改语句

mysqldump --column-statistics=0 -h ip -u root -p lsj2021_practice > D:/lsj2021_practice.sql

报错信息2

mysqldump: Got error: 2005: Unknown MySQL server host 'ip' (2) when trying to connect

修改语句：成功！！！

mysqldump --column-statistics=0 -h 192.168.41.1 -u root -p lsj2021_practice > D:/lsj2021_practice.sql

在这里插入图片描述

版权声明：本文为InitialHeart2021原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。