Skip navigation links

MySQL Forums :: Perl :: Importing a .tsv file into a mysql table


Advanced Search

Importing a .tsv file into a mysql table
Posted by: Hector Mehta ()
Date: October 05, 2011 10:13PM

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

Options: ReplyQuote


Subject Written By Posted
Importing a .tsv file into a mysql table Hector Mehta 10/05/2011 10:13PM
Re: Importing a .tsv file into a mysql table Rick James 10/07/2011 09:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.