MySQL Bugs: #78937: Operation failed with exitcode 7 / unknown variable 'delayed-insert=FALSE'

Bug #78937	Operation failed with exitcode 7 / unknown variable 'delayed-insert=FALSE'
Submitted:	23 Oct 2015 10:44	Modified:	20 Jun 2018 16:25
Reporter:	Axel Werner	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.5 build 201 CE 32bit	OS:	Windows (7 pro german)
Assigned to:		CPU Architecture:	Any
Tags:	regression, windows, workbench

Description:
i run workbench 6.3.5 build 201 CE 32bit on a 64bit windows 7 pro german and experience the same problem as described in Bug #72312, where its supposed to be fixed. 

The "export" of a database that is run on a remote linux SLES 11.sp3 mysql database (as it comes with SLES 11 sp3) failes with 

11:53:39 Dumping dbschemaName (all tables)
Running: mysqldump.exe --defaults-file="c:\users\username\appdata\local\temp\tmpakqmrj.cnf"  --set-gtid-purged=OFF --delayed-insert=FALSE --host=localhost --protocol=tcp --user=root --port=2886 --default-character-set=utf8 --single-transaction=TRUE --routines --events "dbschemaName"
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'

Operation failed with exitcode 7
11:53:39 Export of \\ad\home\username\Desktop\Dump20151023.sql has finished with 1 errors

db the connection goes over "Standard TCPIP over SSH" to a remote Linux Host SLES 11 sp3.  

mysqld  Ver 5.5.43 for Linux on x86_64 (SUSE MySQL package)

How to repeat:
1. connect to remotes server mysql db using tcpip over ssh.
2. Menu server / data export 
3. select db/schema and "objects" to export (procs, functions events etc)
4. export to self contained file => some filename
5. check include create schema
6. start export

Hello Axel Werner,

Thank you for the report.
Verified as described.

Thanks,
Umesh

// MySQL version 5.0.96 with MySQL Workbench Community (GPL) for Windows version 6.3.5 CE build 201 (64 bit)

13:10:33 Dumping test (all tables)
Running: mysqldump.exe --defaults-file="c:\users\umshastr\appdata\local\temp\tmpuhtx57.cnf"  --set-gtid-purged=OFF --delayed-insert=FALSE --host=localhost --protocol=tcp --user=root --port=59468 --default-character-set=utf8 --skip-triggers "test"
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'

Operation failed with exitcode 7
13:10:33 Export of C:\Users\umshastr\Documents\dumps\Dump20151024-1.sql has finished with 1 errors

//MySQL version 5.0.96 with MySQL Workbench Community (GPL) for Windows version 6.3.4  revision 0 build 828 (64 bit)

13:12:35 Dumping test (all tables)
Running: mysqldump.exe --defaults-file="c:\users\umshastr\appdata\local\temp\tmpuzcbu8.cnf"  --set-gtid-purged=OFF --user=root --host=localhost --protocol=tcp --port=16214 --default-character-set=utf8 --skip-triggers "test"
13:12:45 Export of C:\Users\umshastr\Documents\dumps\Dump20151024-1.sql has finished

Temporary fix is offered at http://stackoverflow.com/questions/20128223/export-data-from-mysql-workbench-6-0

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

An error message (Operation failed with exitcode 7) was generated during
the dump operation when an attempt was made to export data running on a
remote server.

Thank you for the bug report.