Hi,
I have a 1GB tab delimited text file that I want to import to Mysql database. It gets imported correctly with Access.
But it does not happen in Mysql. I use the LOAD DATA INFILE statement and all that I get is a message saying that one record has been imported.And that record happens to be filled with the either null or other default values of the column fields. I suspected that this maybe because the first line of the text file contains column names.
Hence,I tried the Load Data with the ignore 1 lines option. But I still get the same result.
CAn any figure out what the problem is.? I would greatly appreciate your answers.
Thanks in Advance!
Nagi
I have a 1GB tab delimited text file that I want to import to Mysql database. It gets imported correctly with Access.
But it does not happen in Mysql. I use the LOAD DATA INFILE statement and all that I get is a message saying that one record has been imported.And that record happens to be filled with the either null or other default values of the column fields. I suspected that this maybe because the first line of the text file contains column names.
Hence,I tried the Load Data with the ignore 1 lines option. But I still get the same result.
CAn any figure out what the problem is.? I would greatly appreciate your answers.
Thanks in Advance!
Nagi