Bug #57939 MySQL Workbench 5.2 CE threw a System.OutOfMemoryException
Submitted: 2 Nov 2010 22:55 Modified: 15 Mar 2011 17:15
Reporter: Dann Corbit Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2 ce OS:Windows (64 bit Windows Server 2008)
Assigned to: CPU Architecture:Any

[2 Nov 2010 22:55] Dann Corbit
Description:
Loading Lahman's Baseball database threw a system out of memory exception

How to repeat:
0.  Get this file and unzip it to a temp folder:
http://baseball1.com/statistics/BDB-sql-2009-11-25.sql.zip

1.  Create a database using the workbench as:
CREATE DATABASE mlb;

2.  Use the database:
USE mlb;

3.  From the workbench, do a File/Open on the file expanded in step 0.

Memory exception was thrown.

Suggested fix:
For large files, read and execute the statements one at a time, instead of reading the whole file into memory.
[15 Mar 2011 17:15] Johannes Taxacher
This is actually a duplicate of Bug #55312