MySQL LOAD DATA INFILE question

Other Forums Beer Garden
1

I’m using LOAD DATA LOCAL INFILE and for some reason it only imports half the data.

I tried doing 68254 rows of data and it did 34127.
I then tried doing 68256 of data and it did 34128.

If I use the replace option and run the query 2 times the second time will import all the data. Any idea? I’m guessing its a setting somewhere, but thought I would post this while I go and look around.

2

Changed:

LINES TERMINATED BY ’
’

to

LINES TERMINATED BY ’
’

and it works now

3

Thanks past Justin, was working on this now and forgot how I fixed it in my testing before.

4

ok :slight_smile:
[SIZE=1]__________________
devices exercises patches pills finance weightloss fitness food gaming aging weightloss [/SIZE]