Bug #54556 Can't load data to a table from a csv file
Submitted: 16 Jun 2010 15:41 Modified: 16 Jun 2010 15:58
Reporter: Juan Miguel Rubio Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.22 RC OS:MacOS (10.6.4)
Assigned to: CPU Architecture:Any
Tags: csv, import

[16 Jun 2010 15:41] Juan Miguel Rubio
Description:
When trying to run a query to load data from a csv file, WB crashes. I know the query works because i can run it from the terminal.

How to repeat:
1. Make a csv file
2. Run the following query:
      load data local infile 'path/to/file.csv'
      into table your.table
      fields terminated by ',' enclosed by '"' lines terminated by '\n'
      (`col1`, `col2`, ... , `coln`);
3. Crash.
[16 Jun 2010 15:58] Johannes Taxacher
this is a duplicate of #49694