#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    5
    Rep Power
    0
    I am currently working on a project that has tons of records that I am importing into MySql. Has anyone here ever done this?? And if so what were the results?

    ------------------
    Man, that was fast!
  2. #2
  3. Full Access
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jun 2000
    Location
    London, UK
    Posts
    2,019
    Rep Power
    17
    I'm in a similar situation, but with only 14,000 records. If they're already in a structured format like an HTML table it's possible to feed in the file name to a PHP program and have that program add the records to a mySQL database. But I have no experience in this. Sorry.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    5
    Rep Power
    0
    I use LOAD DATA INFILE to import them into MySQL and it works okay. I am importing in 150meg increments.

Similar Threads

  1. PHP update record selects the first record only
    By dwmartin in forum PHP Development
    Replies: 11
    Last Post: October 7th, 2003, 04:48 PM
  2. compiling .java, thought I knew what I was doing?!
    By geoffgarcia in forum Java Help
    Replies: 10
    Last Post: September 9th, 2003, 11:56 AM
  3. Code works anywhere else but not on my machine
    By DSteenburg in forum Java Help
    Replies: 4
    Last Post: April 19th, 2003, 09:42 AM
  4. Hiding an empty table or record?
    By UnkFrank in forum PHP Development
    Replies: 1
    Last Post: July 3rd, 2002, 01:19 AM
  5. 'flashing' through divs
    By Roxy in forum HTML Programming
    Replies: 4
    Last Post: April 16th, 2002, 07:15 PM

IMN logo majestic logo threadwatch logo seochat tools logo