Welcome to WebmasterWorld Guest from 54.166.114.43

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



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

WebmasterWorld Senior Member 10+ Year Member



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

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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month