从 mysql Workbench 6.0导出数据

我试图导出我的数据库，在 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'

有人知道怎么帮我吗？

50889 次浏览
小开

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?

小开

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.

小开

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

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

小开

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.

小开

In 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.

小开

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/

小开

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/

小开

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.

小开

I had this error until I upgraded to the latest version. Currently 8.0.15. That fixed it on my Mac.


提交答案