51工具盒子

依楼听风雨
笑看云卷云舒,淡观潮起潮落

【DataGrip】MySQL数据备份报错,mysqldump: unknown table column_statistics in information_schema (1109) ,解决!

报错详情 {#-}

mysqldump: couldnt execute select column_name, json_extract(histogram, $.number-of-buckets-specified) from informationschema.column statistics where schema_name = dblog and table_name = biz_article;: unknown table column_statistics in information_schema (1109)

问题定位 {#-}

提取关键错误信息,如题所示:unknown table column_statistics in information_schema (1109)
查看本地mysql的下载版本是8.0版本
【DataGrip】MySQL数据备份报错,mysqldump: unknown table column_statistics in information_schema (1109) ,解决!
经查询StackOverFlow,解决方案是版本较高,部分参数需要手动添加调整
【DataGrip】MySQL数据备份报错,mysqldump: unknown table column_statistics in information_schema (1109) ,解决!

解决方案 {#-}

导出步骤:
【DataGrip】MySQL数据备份报错,mysqldump: unknown table column_statistics in information_schema (1109) ,解决!
问题解决方式,设置参数
【DataGrip】MySQL数据备份报错,mysqldump: unknown table column_statistics in information_schema (1109) ,解决!

完美解决 {#-}

报错问题没有再出现
【DataGrip】MySQL数据备份报错,mysqldump: unknown table column_statistics in information_schema (1109) ,解决!

赞(0)
未经允许不得转载:工具盒子 » 【DataGrip】MySQL数据备份报错,mysqldump: unknown table column_statistics in information_schema (1109) ,解决!