Notes MYSQL Workbench export table structure and data error mysqldump: [ERROR] unknown variable ' delayed-insert=false '

Source: Internet
Author: User

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 


1, find Workbench installation directory, open folder C:\Program Files (x86) \mysql\mysql Workbench 6.3 ce\modules;

2. Find Python file 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
# 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"]
#    },
    "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"]
    "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"]

4. Save the file and restart Workbench to export the database library normally.

Original address:

Notes MYSQL Workbench export table structure and data error mysqldump: [ERROR] unknown variable ' delayed-insert=false '

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.