无法从mysql工作台导出我的数据库 [英] Can't export my database from mysql workbench

问题描述

我正在尝试从MySQL Workbench导出数据库，但是我在导出过程中得到了这个信息:

I am trying to export my database from MySQL Workbench but I get this during the export progress:

运行:mysqldump.exe --defaults-file ="c:\ users \ user \ appdata \ local \ temp \ tmp2h91wa.cnf""--user = root --host = localhost --protocol = tcp --port = 3306 --default-character- set = utf8 --skip-triggers"mydb" mysqldump:无法执行'SELECT COLUMN_NAME，
JSON_EXTRACT(HISTOGRAM，'$.指定的桶数"')
从information_schema.COLUMN_STATISTICS在哪里 SCHEMA_NAME ='mydb'AND TABLE_NAME ='courses';':未知表 information_schema(1109)中的"column_statistics"

Running: mysqldump.exe --defaults-file="c:\users\user\appdata\local\temp\tmp2h91wa.cnf" --user=root --host=localhost --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers "mydb" mysqldump: Couldn't execute 'SELECT COLUMN_NAME,
JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')
FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'mydb' AND TABLE_NAME = 'courses';': Unknown table 'column_statistics' in information_schema (1109)

操作失败，退出代码2 20:55:09导出 C:\ Users \ user \ Documents \ dumps \ mydb.sql完成1错误

Operation failed with exitcode 2 20:55:09 Export of C:\Users\user\Documents\dumps\mydb.sql has finished with 1 errors

您知道什么地方可能出问题吗? 谢谢

Do you have any idea what might going wrong? Thanks

推荐答案

在MySql Workbench版本8.0.13中，执行以下步骤:

In MySql Workbench version 8.0.13 do the following steps:

1. 转到管理/数据导出"
2. 在要导出的表"列表中选择要导出的模式
3. 点击高级选项..."按钮(右上方)
4. 搜索选项其他/列统计"
5. 将值设置为0
6. 点击返回"按钮(右上方)

现在它应该可以工作了.不幸的是，每次启动MySql Workbench时都必须这样做.

Now it should work. Unfortunately, you'll have to do that every time you start MySql Workbench.

这篇关于无法从mysql工作台导出我的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！