Importing a .tsv file into a mysql table

[Hector Mehta]

Hi All,

I have a tab separated file (.tsv) which I would like to import into a table. The file is large (around 11GB) in size with 256 columns.

I tried running the following command from the mysql prompt

LOAD DATA LOCAL INFILE 'importfile.tsv'
INTO TABLE test.destination_table
LINES TERMINATED BY '\n';

and it would only copy the first row of the file.

How do I get the entire data set in ? Alternately, if there is another way to do it thru the Workbench interface - that would be even better. Any suggestions, let me know.

Thanks for your help in advance
hector