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
• Status: Duplicate
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2 ce
• OS: Windows (64 bit Windows Server 2008)
• 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