从mysql Workbench 6.0导出数据。

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:

我正在尝试导出我的数据库，使用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'

Does anybody have any idea that can help me?

有人有什么想法可以帮助我吗?

8 个解决方案

#1

mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'

mysqldump: [ERROR]未知变量'delayed-insert=FALSE'

This error occurs on various systems and can be temporarily fixed by:

这个错误发生在不同的系统上，可以临时固定:

1. Going to the appropriate directory depending on the system:

   根据系统进入适当的目录:

   a) Windows: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules (32-bit installation on x64 systems: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules)

   6.3)Windows:C:\Program Files\MySQL\MySQL工作台CE \模块(6.3 32位安装在x64系统:C:\Program Files (x86)\MySQL\MySQL工作台CE \模块)

   b) Mac OS X: Applications/MYSQLWorkbench.app/Contents/Resources/plugins - right click on the app and select Show Package contents to get inside the app (thanks to Bradley Flood)

   b) Mac OS X: application /MYSQLWorkbench。app/内容/资源/插件——右键点击app，选择Show Package Contents进入app(感谢Bradley Flood)

   c) Linux Ubuntu: /usr/lib/mysql-workbench/modules (thanks to Alessandro Lopes)

   c) Linux Ubuntu: /usr/lib/mysql工作台/模块(感谢Alessandro Lopes)

2. Open file wb_admin_export_options.py

   打开文件wb_admin_export_options.py

3. Find line "delayed-insert":["Write INSERT DELAYED statements rather than ...

   查找行“延迟插入”:[“写入插入延迟语句而不是……”

4. Insert # at the begin of this line to comment it out

   在这一行的开头插入#以注释掉它

5. Save file and restart Workbench.

   保存文件和重启工作台。

Tested on Windows 7 x64, MySQL 5.6.27 (MyISAM) & Workbench 6.3.5 x64.

在Windows 7 x64、MySQL 5.6.27 (MyISAM)和Workbench 6.3.5 x64上进行测试。

Tested on OSX Yosemite 10.10.4, MySQL 5.5.27 (MyISAM), Workbench 6.3.5 build 201 CE x64.

在OSX Yosemite 10.10.4、MySQL 5.5.5.27 (MyISAM)、Workbench 6.3.5构建201 CE x64上进行测试。

#2

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)

编辑该文件C:\Program Files\MySQL\MySQL CE \模块\ wb_admin_export_options 6.3工作台。py(确保以管理员的身份打开编辑器)

find the line:

找到:

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

延迟插入":["写入插入延迟语句，而不是插入语句。”、“假”、“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")],

“写入插入延迟语句而不是插入语句”。”、“假”、“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.

启动Workbench并再次尝试。

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

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

#3

On Linux Ubuntu/Mint:

在Linux Ubuntu /薄荷:

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

配置文件位于:/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...

正如c4pricorn所描述的，只需注释行“延迟插入”:[“写入插入延迟语句而不是……”

And restart workbench.

并重新启动工作台。

#4

Delayed inserts where deprecated in 5.6 and are converted to normal inserts in 5.7 (see also http://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html). I wonder why mysqldump reports an error on this. Regardless, MySQL Workbench must be adjusted to no use delayed-insert for dumps. Can you please file a bug report at http://bugs.mysql.com to bring this on the agenta for MySQL Workbench?

延迟插入在5.6中被废弃，在5.7中被转换为普通插入(参见http://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html)。我想知道为什么mysqldump报告了这个错误。无论如何，MySQL Workbench必须调整为不使用延迟插入转储。你能不能在http://bugs.mysql.com上提交一个错误报告，把它放在MySQL工作台的代理上?

#5

In CentOS 7,

在CentOS 7中,

Open file /usr/lib64/mysql-workbench/modules/wb_admin_export_options.py Find line "delayed-insert":["Write INSERT DELAYED statements rather than ... Insert # at the begin of this line to comment it out Save file and restart Workbench.

打开文件/usr/lib64/mysql-workbench /模块/ wb_admin_export_options。py找到行“延迟插入”:["写入插入延迟语句而不是…在这一行的开头插入#以注释它，保存文件并重新启动工作台。

#6

As highlighted at an earlier post, by putting a # at the delayed-insert line in wb_admin_export_options.py does solves the problem.What i like to add is that when i tried to edit it in notepad and Pythonwin,i encountered the admin rights issue.They don't let me save the file after my edit.I finally work around it by editing and saving it in notepad++.One can download it from here https://notepad-plus-plus.org/

正如在前面的文章中突出显示的，在wb_admin_export_options的延迟插入行中放置一个#。py确实解决了这个问题。我想补充的是，当我尝试在记事本和Pythonwin中编辑它时，我遇到了管理权限问题。他们不让我在编辑后保存文件。我最终通过编辑并保存在记事本++中来解决这个问题。可以从这里下载https://notepad-plus-plus -plus-plus - org/

#7

Removing delayed-insert line in wb_admin_export_options.py solves the problem. You need to get admin rights to modify the file.

删除wb_admin_export_options中的延迟插入行。py解决问题。您需要获得修改文件的管理权限。

Nonetheless consider that your MySQL database might have been not properly upgraded before.

尽管如此，请考虑您的MySQL数据库以前可能没有正确地升级。

#8

Be careful on editor: on Win7 64 notepad doesn't work on this modification. Notepad will present a single line, use an editor with crlf.

在编辑器上要小心:在win764 notepad上不能进行此修改。记事本将显示一行，使用crlf编辑器。