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