1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    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.

    Please help.
  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    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!


Similar Threads

  1. Replies: 0
    Last Post: February 11th, 2004, 02:56 PM
  2. Newbie trying to load data file
    By wab25 in forum Flash Help
    Replies: 2
    Last Post: February 6th, 2004, 04:21 PM
  3. how to load data from excel into C++ Application
    By lenochka in forum C Programming
    Replies: 5
    Last Post: July 10th, 2003, 08:08 AM
  4. LOAD DATA INFILE - does not ignore header row
    By aliciawee in forum MySQL Help
    Replies: 0
    Last Post: March 20th, 2003, 09:11 PM
  5. Retrieving data from multiple rows
    By Entemedia in forum MySQL Help
    Replies: 1
    Last Post: September 30th, 2001, 07:10 AM

IMN logo majestic logo threadwatch logo seochat tools logo