Description:
When trying to export a schema from MySQL 5.7.4, Workbench returns the following:
--
15:15:48 Dumping ucsdnews (all tables)
Running: /usr/local/mysql/bin/mysqldump --defaults-file="/var/folders/xr/mwj65wr51hd52s8bnmrhpkr80000gp/T/tmpiKA0uN/extraparams.cnf" --max_allowed_packet=1G --delayed-insert=FALSE --host=localhost --user=root --port=3306 --default-character-set=utf8 "ucsdnews"
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'
Operation failed with exitcode 7
15:15:49 Export of /Users/matthew/Desktop/test-dump.sql has finished with 1 errors
--
The error occurs when the mysqldump location is configured to point to the version of mysqldump in MySQL 5.7.4.
When the mysqldump location is left as the default, the dump will continue, but I am warned about the version mismatch:
--
mysqldump Version Mismatch
/Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump is version 5.6.17, but the MySQL Server to be dumped has version 5.7.4-m14.
Because the version of mysqldump is older than the server, some features may not be backed up properly.
It is recommended you upgrade your local MySQL client programs, including mysqldump to a version equal to or newer than that of the target server.
The path to the dump tool must then be set in Preferences -> Administrator -> Path to mysqldump Tool:
--
I have tried multiple versions of Workbench (6.0.9, 6.1.6 and 6.1.7), all seem to behave identically.
How to repeat:
Export to a Dump Project folder or to a Self-Contained file
Suggested fix:
Remove the delayed-insert parameter if it is no longer supported in databases 5.6 and above.
