Use MySQL Workbench in the afternoon to export the database table structure, after setting export options to perform the export, reported the following error:
16:22:40 Dumping nacweixindb (tb_app)
Running: mysqldump.exe --defaults-file="c:\users\admini~1\appdata\local\temp\tmpswfutq.cnf" --delayed-insert=FALSE
--host=localhost --protocol=tcp --user=root --port=3306 --default-character-set=utf8
--single-transaction=TRUE --skip-triggers "test_db"
mysqldump: [ERROR] unknown variable ‘delayed-insert=FALSE‘
Operation failed with exitcode 7
16:22:41 Export of C:\Users\Administrator\Documents\dumps\Dump20160720-2.sql has finished with 1 errors
The export operation has no effect, so start Google, and finally to the MySQL bug list found
Bug #71811 Workbench can‘t create a Single Transaction dump
Solution:
1, find Workbench installation directory, open folder C:\Program Files (x86) \mysql\mysql Workbench 6.3 ce\modules;
2. Find Python file wb_admin_export_options.py in Modules folder;
3, note the 29th line of code, as follows:
# Copyright (c) 2007, 2015, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License as
# published by the Free Software Foundation; version 2 of the
# License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
# 02110-1301 USA
export_options = {
# "Tables":{
# "no-create-info":["Do not write CREATE TABLE statements that re-create each dumped table.","FALSE"],
# "skip-triggers":["Do not dump triggers", "FALSE"]
# },
# "Databases":{
# "add-drop-database":["Add a DROP DATABASE statement before each CREATE DATABASE statement.","FALSE"],
# "no-create-db":["This option suppresses the CREATE DATABASE statements.","FALSE"]
# },
"Inserts":{
"extended-insert":["Use multiple-row INSERT syntax that include several VALUES lists.","TRUE"],
"delayed-insert":["Write INSERT DELAYED statements rather than INSERT statements.","FALSE", "BOOL", ("5.0.0", "5.7.0")],
# "add-locks":["Surround each table dump with LOCK TABLES and UNLOCK TABLES statements.","TRUE"],
"replace":["Write REPLACE statements rather than INSERT statements.","FALSE"],
"insert-ignore":["Write INSERT IGNORE statements rather than INSERT statements.","FALSE"],
"complete-insert":["Use complete INSERT statements that include column names.","FALSE"]
},
"SQL":{
"create-options":["Include all MySQL-specific table options in CREATE TABLE statements.","TRUE"],
"quote-names":["Quote identifiers within backtick characters.","TRUE"],
"allow-keywords":["Allow creation of column names that are keywords.","FALSE"]
},
"Other":{
4. Save the file and restart Workbench to export the database library normally.
Original address:
https://bugs.mysql.com/bug.php?id=71811
http://www.serveradminblog.com/2015/12/unable-to-export-database-in-mysql-workbench/
Notes MYSQL Workbench export table structure and data error mysqldump: [ERROR] unknown variable ' delayed-insert=false '