SQL error. Need Help!!!

Discussion in 'Databases' started by demondestiny, Jan 22, 2009.

  1. #1
    Hi, i am using phpmyadmin to import this SQL file. When i do it comes up with an error saying,

    #1062 - Duplicate entry '1' for key 1

    I am not sure what this means and don't know what to do. Any help would be much appreciated.
     
    demondestiny, Jan 22, 2009 IP
  2. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #2
    It means that there is already a record in the DB that contains that value for that field.

    If this is a new DB you could try making sure that it is empty before you start. Import may have failed after a partial import creating the problem.
     
    Colbyt, Jan 22, 2009 IP
  3. demondestiny

    demondestiny Peon

    Messages:
    65
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thankyou i did that and it works.
     
    demondestiny, Jan 23, 2009 IP