程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> MySQL綜合教程 >> [筆記] MySql Workbench 導出表結構和數據報錯 mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE',unknownvariable

[筆記] MySql Workbench 導出表結構和數據報錯 mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE',unknownvariable

編輯:MySQL綜合教程

[筆記] MySql Workbench 導出表結構和數據報錯 mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE',unknownvariable


下午使用MySql Workbench導出數據庫表結構,設置完導出選項後執行導出,報如下錯誤:

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

多次執行導出操作無果,於是開始google,終於到mysql bug list中找到

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

 

解決方案:

1、找到Workbench安裝目錄,打開文件夾C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules;

2、在modules文件夾中找到python文件wb_admin_export_options.py;

3、注釋第29行代碼,如下:   

# 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、保存文件, 重啟Workbench即可正常導出數據庫庫。

 

原文地址:

https://bugs.mysql.com/bug.php?id=71811

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

 

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved