从mysql Workbench导出数据 6.0

本文是小编为大家收集整理的关于从mysql Workbench导出数据 6.0的处理/解决方法，可以参考本文帮助大家快速定位并解决问题，中文翻译不准确的可切换到English标签页查看源文。

中文
English

问题描述

我正在尝试使用Windows上的MySQL WorkBench 6.0导出数据库，以将其发送到Amazon RDS中的DB实例，但我遇到了此错误:

Operation failed with exitcode 7
11:34:40 Dumping clubbin (taxicompanies)
Running: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe"
-defaults-extra- file="c:\users\selene\appdata\local\temp\tmp6o0hno.cnf"
--max_allowed_packet=1G --delayed-   insert=FALSE --host=localhost --user=root
--port=3306 --default-character-set=utf8 "clubbin"   "taxicompanies"
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'

有人有任何想法可以帮助我吗?

其他推荐答案

这对我有用.

编辑文件c:\ program文件\ mysql \ mysql workbench 6.3 CE \模块\ wb_admin_export_options.py(确保您作为管理员打开编辑器)

找到行:

延迟插入":["写入插入延迟语句而不是插入语句."，" false"，" bool"，(" 5.0.0"，" 5.7.0")]，

并在行的开头放一个哈希"#"，以使其看起来像这样:

#delayed-insert":["写入插入延迟语句而不是插入语句."，" false"，" bool"，(" 5.0.0"，" 5.7.0")]，

这将评论该线路，以使工作台不会使用此声明.

保存并关闭文件.

启动工作台然后重试.

参考/

其他推荐答案

在Linux ubuntu/mint上:

配置文件位于: /USR/lib/mysql-workbench/modules/wb_admin_export_options.py

如C4Pricorn所述，只需评论"延迟插入"行:["写入插入延迟语句，而不是...

和重新启动工作台.

本文地址：https://www.itbaoku.cn/post/597387.html

百度翻译此文有道翻译此文

问题描述

I'm trying to export my database, using MySQL Workbench 6.0 on Windows, to send to my db instance in Amazon RDS, but i'm getting this error:

Operation failed with exitcode 7
11:34:40 Dumping clubbin (taxicompanies)
Running: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe"
-defaults-extra- file="c:\users\selene\appdata\local\temp\tmp6o0hno.cnf"
--max_allowed_packet=1G --delayed-   insert=FALSE --host=localhost --user=root
--port=3306 --default-character-set=utf8 "clubbin"   "taxicompanies"
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'

Does anybody have any idea that can help me?

其他推荐答案

This worked for me.

Edit the file C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_export_options.py (make sure you open your editor as administrator)

find the line:

delayed-insert":["Write INSERT DELAYED statements rather than INSERT statements.","FALSE", "BOOL", ("5.0.0", "5.7.0")],

and put a hash “#” at the beginning of the line so that it looks like this:

# delayed-insert":["Write INSERT DELAYED statements rather than INSERT statements.","FALSE", "BOOL", ("5.0.0", "5.7.0")],

This will comment the line out so that Workbench won’t use this statement.

Save and close the file.

Start Workbench and try again.

Reference http://dannytsang.co.uk/mysql-workbench-error-code-7/

其他推荐答案

On Linux Ubuntu/Mint:

The config file is located at : /usr/lib/mysql-workbench/modules/wb_admin_export_options.py

As described by c4pricorn, simply comment the line "delayed-insert":["Write INSERT DELAYED statements rather than...

And restart workbench.

上一篇：重置数据库（清除所有），然后播种一个数据库

下一篇：什么时候不使用卡桑德拉?