从mysql Workbench 6.0导出数据

问题描述

我试图导出我的数据库，在Windows上使用MySQL Workbench 6.0，发送到我的数据库实例在Amazon RDS，但我得到这个错误：

 操作失败退出代码7 
 11:34:40转储俱乐部（taxicompanies）
运行：C：\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe
 -defaults-extra- file =c：\users\selene\appdata\local\temp\tmp6o0hno.cnf
  - -max_allowed_pa​​cket = 1G --delayed- insert = FALSE --host = localhost --user = root 
 --port = 3306 --default-character-set = utf8clubbintaxicompanies
 mysqldump ：[ERROR] unknown variable'delayed-insert = FALSE'
  

解决方案

此错误发生在各种系统上，可以暂时修正：

1. 根据系统，转到相应的目录：

   
   
   

   a） Windows ： C：\Program Files\ MySQL \MySQL Workbench 6.3 CE\modules （在x64系统上32位安装： C：\Program Files （x86）\MySQL\MySQL Workbench 6.3 CE\modules ）

   
   
   

   b） Mac OS X ：应用程序/ MYSQLWorkbench.app / Contents / Resources / plugins - 右键单击​​应用程序并选择显示包内容以获取应用程序（感谢）

   
   
   

   c） Linux Ubuntu ： / usr / lib / mysql-workbench / modules （感谢）




2. 打开文件 wb_admin_export_options.py




3. 查找行delayed-insert：[编写INSERT DELAYED语句，而不是...




4. 在此行开头插入＃即可注释

在Windows 7 x64，MySQL 5.6.27（MyISAM ）& Workbench 6.3.5 x64。

在OSX Yosemite 10.10.4，MySQL 5.5.27（MyISAM），Workbench 6.3.5 build 201 CE x64上测试。

I'm trying to export my database, using MySQL Workbench 6.0 on Windows, to send to my db instance in Amazon RDS, but i'm getting this error:

Operation failed with exitcode 7
11:34:40 Dumping clubbin (taxicompanies)
Running: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe"
-defaults-extra- file="c:\users\selene\appdata\local\temp\tmp6o0hno.cnf"
--max_allowed_packet=1G --delayed-   insert=FALSE --host=localhost --user=root
--port=3306 --default-character-set=utf8 "clubbin"   "taxicompanies"
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'

Does anybody have any idea that can help me?

解决方案

This error occurs on various systems and can be temporarily fixed by:

1. Going to the appropriate directory depending on the system:

   a) Windows: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules (32-bit installation on x64 systems: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules)

   b) Mac OS X: Applications/MYSQLWorkbench.app/Contents/Resources/plugins - right click on the app and select Show Package contents to get inside the app (thanks to Bradley Flood)

   c) Linux Ubuntu: /usr/lib/mysql-workbench/modules (thanks to Alessandro Lopes)

2. Open file wb_admin_export_options.py

3. Find line "delayed-insert":["Write INSERT DELAYED statements rather than ...

4. Insert # at the begin of this line to comment it out

5. Save file and restart Workbench.

Tested on Windows 7 x64, MySQL 5.6.27 (MyISAM) & Workbench 6.3.5 x64.

Tested on OSX Yosemite 10.10.4, MySQL 5.5.27 (MyISAM), Workbench 6.3.5 build 201 CE x64.

这篇关于从mysql Workbench 6.0导出数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！