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)

10+ Year Member


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 Jun 19, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

You should try LOAD DATA INFILE:

If If you're on windows then try:


Featured Threads

Hot Threads This Week

Hot Threads This Month