mysql 6.0ce 导出,从mysql Workbench 6.0导出数据

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?

解决方案mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'

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-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)

Open file wb_admin_export_options.py

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

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

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.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值