Export Data from mysql Workbench 6.0

Question

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?

Answer 1

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.

Answer 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)

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/