MySQL Workbench Error Code 7

Overview

On Windows, I was getting the following error trying to take a database dump to file:
mysqldump: [ERROR] unknown variable 'delayed-insert=FALSE'
Operation failed with exitcode 7

At the time I was using Workbench 6.3.5.

Temporary Fix

Edit the file C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\wb_admin_export_options.py (make sure you open your editor as administrator)

find the line:
delayed-insert":["Write INSERT DELAYED statements rather than INSERT statements.","FALSE", "BOOL", ("5.0.0", "5.7.0")],
and put a hash “#” at the beginning of the line so that it looks like this:
# delayed-insert":["Write INSERT DELAYED statements rather than INSERT statements.","FALSE", "BOOL", ("5.0.0", "5.7.0")],

This will comment the line out so that Workbench won’t use this statement.

Save and close the file.

Start Workbench and try again.

Export Data from mysql Workbench 6.0

About Danny

I.T software professional always studying and applying the knowledge gained and one way of doing this is to blog. Danny also has participates in a part time project called Energy@Home [http://code.google.com/p/energyathome/] for monitoring energy usage on a premise. Dedicated to I.T since studying pure Information Technology since the age of 16, Danny Tsang working in the field that he has aimed for since leaving school. View all posts by Danny → This entry was posted in Database and tagged backup, mysql, Windows, Workbench. Bookmark the permalink.

4 Responses to MySQL Workbench Error Code 7

This site uses Akismet to reduce spam. Learn how your comment data is processed.