Welcome to WebmasterWorld Guest from 54.161.99.20

Forum Moderators: open

Message Too Old, No Replies

Importing large text files in Mysql

     
7:34 am on Jun 19, 2007 (gmt 0)

Full Member

10+ Year Member

joined:Aug 29, 2003
posts:244
votes: 0


Hi,

I'm trying to import a very large text file (about 250MB) into a Mysql table. How can I best do this? The text file has 4 columns delimited by a tab and in some columns there is no information.

Turbo

5:40 pm on June 19, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 27, 2001
posts:2547
votes: 0


You should try LOAD DATA INFILE:
[dev.mysql.com...]

If If you're on windows then try:
[dev.mysql.com...]