Export Data from mysql Workbench 6.0

原文地址：export-data-from-mysql-workbench-6-0

1. 问题描述

   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 FilesMySQLMySQL Server 5.7inmysqldump.exe"
-defaults-extra- file="c:usersseleneappdatalocal	emp	mp6o0hno.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'

2.解决方式:

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

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

Going to the appropriate directory depending on the system:

a) Windows: C:Program FilesMySQLMySQL Workbench 6.3 CEmodules (32-bit installation on x64 systems: C:Program Files (x86)MySQLMySQL Workbench 6.3 CEmodules)

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)

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


Tested on MySQL 5.6.27 (MyISAM) & Workbench 6.3.5 x64 (Windows 7 x64) with no errors.

	
Confirmed it works, thanks. – Mario Lopez Oct 29 at 1:23
15	 	
For users on OSX the wb_admin_export_options.py file is located in Applications -> MYSQLWorkbench.app/Contents/Resources/plugins. Note: right click on the app and select Show Package contents to get inside the app. – Bradley Flood Oct 29 at 2:57
  	 	
Fresh install of all new MySQL software on a new Mac with all updates as of Nov 1st, 2015. This fixes the export data issue. Thanks! – halfnibble Nov 1 at 22:55
  	 	
For Ubuntu users the is located at /usr/lib/mysql-workbench/modules/wb_admin_export_options.py – Brian Leishman Nov 9 at 15:08
  	 	
this was a great help, thanks – shifter Nov 17 at 2:34