November 22nd, 1999, 03:07 PM
I have a table named test and I would like to be able to load records into it from my local pc. I have a local file named test.txt and a form that executes the load script(php) on the server. If test is empty the records go in fine. The problem is that I want to remove many of the records before I load the new ones so I delete from test where hold = 1 and then load the new records. It adds two records and the stops. I don't get an error message it just doesn't add all of the records.
December 14th, 1999, 09:44 AM
I need more information on this. Is your server Unix and your local pc Windows?
Then the problem could be in the line termination: in windows 'rn', in Unix only 'r'.
So check the syntax of the LOAD DATA INFILE, especially the "LINES TERMINATED BY" part. Play around and see which line-termination works.
I have had the same problem and finally got it right.
Keep it up!