从mysql Workbench 6.0导出数据 [英] Export Data from mysql Workbench 6.0
问题描述
我试图导出我的数据库,在Windows上使用MySQL Workbench 6.0,将其发送到Amazon RDS中的数据库实例,但是我收到以下错误:
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'
有人有任何想法可以帮助我的?$ / b>
Does anybody have any idea that can help me?
推荐答案
mysqldump:[ERROR]未知变量'delayed-insert = FALSE' p>
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'
这种错误发生在各种系统上,可以暂时性y确定:
This error occurs on various systems and can be temporarily fixed by:
-
根据系统进入相应的目录:
Going to the appropriate directory depending on the system:
a) Windows : C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules
(32位安装在x64系统上: C:\程序文件(x86)\MySQL\MySQL Workbench 6.3 CE\modules
)
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 :应用程序/ MYSQLWorkbench.app / Contents / Resources / plugins
- 右键单击应用程序并选择显示包内容以进入应用程序(感谢 Bradley Flood )
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
(感谢 Alessandro Lopes )
打开文件 wb_admin_export_options。 py
查找行delayed-insert:[Write INSERT DELAYED语句而不是...
在开始时插入#
的这一行来评论
Insert #
at the begin of this line to comment it out
保存文件并重启Workbench。
Save file and restart Workbench.
在Windows 7 x64,MySQL 5.6.27(MyISAM)& Workbench 6.3.5 x64。
Tested on 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上测试。
Tested on OSX Yosemite 10.10.4, MySQL 5.5.27 (MyISAM), Workbench 6.3.5 build 201 CE x64.
这篇关于从mysql Workbench 6.0导出数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!