首页 / MYSQL / [笔记] MySql Workbench 导出表结构和数据报错 mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'
[笔记] MySql Workbench 导出表结构和数据报错 mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了[笔记] MySql Workbench 导出表结构和数据报错 mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE',小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2876字,纯文字阅读大概需要5分钟。
内容图文
![[笔记] MySql Workbench 导出表结构和数据报错 mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'](/upload/InfoBanner/zyjiaocheng/468/37cfcea1f0824c569fc9dae4f3ddcc41.jpg)
--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即可正常导出数据库库。
内容总结
以上是互联网集市为您收集整理的[笔记] MySql Workbench 导出表结构和数据报错 mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'全部内容,希望文章能够帮你解决[笔记] MySql Workbench 导出表结构和数据报错 mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。