[Note] mysqldump: [ERROR] unknown variable & #39; delayed-insert = FALSE & #39;, unknownvariable

[Note] mysqldump: [ERROR] unknown variable 'delayed-insert = false', unknownvariable

In the afternoon, use MySql Workbench to export the database table structure. After setting the export options, run the Export command. The following error is returned:

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 716:22:41 Export of C:\Users\Administrator\Documents\dumps\Dump20160720-2.sql has finished with 1 errors

Multiple export operations failed, so I started to google and finally found it in the mysql bug list.

Bug #71811 Workbench can't create a Single Transaction dump

 

Solution:

1. Find the Workbench installation directory and open the folder C: \ Program Files (x86) \ MySQL Workbench 6.3 CE \ modules;

2. Find the python file wb_admin_export_options.py in the modules folder;

3. Comment out 29th lines of code, as shown below:

# 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  USAexport_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.

 

Original article address:

Https://bugs.mysql.com/bug.php? Id = 71811

Http://www.serveradminblog.com/2015/12/unable-to-export-database-in-mysql-workbench/