从mysql Workbench导出数据 6.0[英] Export Data from mysql Workbench 6.0

本文是小编为大家收集整理的关于从mysql Workbench导出数据 6.0的处理/解决方法,可以参考本文帮助大家快速定位并解决问题,中文翻译不准确的可切换到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'

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

推荐答案

mysqldump:[错误]未知变量'delayed-insert = false'


此错误发生在各种系统上,可以通过:

暂时修复.
  1. 根据系统而转到适当的目录:

    a) Windows :C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules(X64系统上的32位安装:C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules)

    b) Mac OS X :Applications/MYSQLWorkbench.app/Contents/Resources/plugins - 右键单击​​该应用程序,然后选择" Show package contents"以进入应用程序(感谢布拉德利洪水)

    c) linux ubuntu :/usr/lib/mysql-workbench/modules(感谢 alessandro lopes "> alessandro lopes )

  2. 打开文件wb_admin_export_options.py

  3. 查找行"delayed-insert":["Write INSERT DELAYED statements rather than ...

  4. 插入#在此行的开头,以评论

  5. 保存文件并重新启动Workbench.


在Windows 7 X64,MySQL 5.6.27(Myisam)和Workbench上测试了6.3.5 x64.

在OSX Yosemite 10.10.4,MySQL 5.5.27(Myisam),Workbench 6.3.5构建201 CE X64.

上测试.

其他推荐答案

这对我有用.

编辑文件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?

推荐答案

mysqldump: [ERROR] unknown variable '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)

    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)

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

  2. Open file 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.

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

其他推荐答案

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.