Welcome to WebmasterWorld Guest from

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
votes: 0


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.


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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 27, 2001
votes: 0

You should try LOAD DATA INFILE:

If If you're on windows then try: