MySQL Bugs: #79255: Workbench 6.3 CE (just installed) has errors dumping each table--mysqldump: [ERR

Bug #79255	Workbench 6.3 CE (just installed) has errors dumping each table--mysqldump: [ERR
Submitted:	12 Nov 2015 20:48	Modified:	24 May 2018 15:33
Reporter:	Robert Moore	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S5 (Performance)
Version:	6.3.5	OS:	Windows (Microsoft Windows 7 Home Premium Service Pack 1)
Assigned to:	Miguel Tadeu Mota	CPU Architecture:	Any
Tags:	export, WBBugReporter, workbench

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\RFM\AppData\Roaming\MySQL\Workbench\log\wb.log]

Errors for export of a database. Every table resulted in, e.g., this message:

Running: mysqldump.exe --defaults-file="c:\users\rfm\appdata\local\temp\tmpmkwnwo.cnf"  --delayed-insert=FALSE --host=localhost --protocol=tcp --user=root --port=3306 --default-character-set=utf8 --skip-triggers "budget_mgr_3" "account_period_start"

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

Operation failed with exitcode 7

How to repeat:
Run any of my schemas with same results. 'delayed-insert' is always tried but always an unknown variable.

Thank you for the bug report.

21:04:41 Dumping world (city)
Running: mysqldump.exe --defaults-file="c:\users\miguel\appdata\local\temp\tmpq9od9y.cnf"  --delayed-insert=FALSE --host=localhost --protocol=tcp --user=root --port=3306 --default-character-set=utf8 --skip-triggers "world" "city"
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'

Operation failed with exitcode 7
21:04:41 Dumping world (country)
Running: mysqldump.exe --defaults-file="c:\users\miguel\appdata\local\temp\tmpditage.cnf"  --delayed-insert=FALSE --host=localhost --protocol=tcp --user=root --port=3306 --default-character-set=utf8 --skip-triggers "world" "country"
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'

Operation failed with exitcode 7
21:04:41 Dumping world (countrylanguage)
Running: mysqldump.exe --defaults-file="c:\users\miguel\appdata\local\temp\tmp1wkorp.cnf"  --delayed-insert=FALSE --host=localhost --protocol=tcp --user=root --port=3306 --default-character-set=utf8 --skip-triggers "world" "countrylanguage"
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'

Operation failed with exitcode 7
21:04:42 Export of C:\Users\miguel\Documents\dumps\Dump20151112 has finished with 3 errors

The   option --delayed-inserts is not listed here https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#mysqldump-option-summary.

This probably happened as a consequence of (as I understand) INSERT DELAYED syntax having been removed from the server in MySQL 5.7 (it was deprecated in 5.6).

So what is the bug here?

-- Peter
-- not a MySQL/Oracle person.

OK .. got it.  This bug was reported as a Workbench bug.

http://bugs.mysql.com/bug.php?id=79263 marked as duplicate of this one.

Am experiencing the same problem (6.3.5 Build 201 CE on W7 64).

C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_export_options.py dated 10/17/2015 contains the line:

"delayed-insert":["Write INSERT DELAYED statements rather than INSERT statements.","FALSE", "BOOL", ("5.0.0", "5.7.0")],

Does this not tell the processor to only include the delayed-insert parameter for versions 5.0.0 - 5.7.0?  Is this a Workbench bug, or is it possible a prior MySQL or Workbench upgrade did not complete successfully on my PC?  Or something else?

I commented out the line per http://stackoverflow.com/questions/20128223/export-data-from-mysql-workbench-6-0 as a workaround...

Already fixed. This is a duplicate of an internal bug.