Export Data from mysql Workbench 6.0

Rodrigo Araujo picture Rodrigo Araujo · Nov 21, 2013 · Viewed 48.9k times · Source

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

c4pricorn picture c4pricorn · Oct 28, 2015

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.