#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    108
    Rep Power
    15
    Hello,

    I am working with LOAD DATA INFILE (to add LOTS of data to a database). I loaded a large text file with data, but the command only went through about half of the data. I did receive an error that a Primary Key found multiple of one thing.. would that stop the competion of loading the data?

    Thanks! http://www.datera.com
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    yoshi,

    i think your database is having a primary key.i guess some values in your textfile are duplicating .That is why it's giving an error.just check it out your textfile values.









    ------------------
    SR -
    shiju.dreamcenter.net
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    108
    Rep Power
    15
    thanks!

    I just figured it out.. you were right.

    yoshi http://www.datera.com

Similar Threads

  1. Load Data Infile after Upload!
    By georgeatef in forum PHP Development
    Replies: 7
    Last Post: December 14th, 2003, 03:06 AM
  2. LOAD DATA INFILE for 500K records
    By sierrasenthil in forum MySQL Help
    Replies: 4
    Last Post: September 18th, 2003, 07:51 AM
  3. Load local data infile problem
    By Prathmesh in forum MySQL Help
    Replies: 11
    Last Post: June 3rd, 2003, 10:47 AM
  4. Load data infile and null values
    By joebw in forum MySQL Help
    Replies: 4
    Last Post: February 1st, 2003, 11:22 AM
  5. Load DATA infile via a shell script ?
    By techformation in forum MySQL Help
    Replies: 2
    Last Post: December 20th, 2002, 08:48 PM

IMN logo majestic logo threadwatch logo seochat tools logo