MySQL error

Discussion in 'MySQL' started by RosenCruz, Aug 2, 2009.

0
  1. #1
    While moving my SMF forum to myhost from another one i got back up..and while importing it to the new one with phpmyadmin i get this error..can anyone help...i will really appreciate....:(

    INSERT INTO `smf_log_search_subjects` (`word`, `ID_TOPIC`) VALUES (5, 78), (5, 83), (5, 137), (5, 198), (5, 251), (5, 297), (5, 328), (5, 351), (5, 362), (5, 404), (5, 420), (5, 533), (5, 598), (5, 599), (5, 622), (5, 697), (5, 791), (5, 889), (5, 1015), (5, 1040), (5, 1103), (5, 1104), (5, 1137), (5, 1143), (5, 1160), (5, 1162), (5, 1190), (5, 1208), ('5-6', 1108), (50, 370), (50, 804), (50, 975), (50, 1025), (50, 1156), (500, 1196), ('51mb', 1028), (57, 975), ('5dvd', 330), (6, 364), (6, 785), (6, 790), (6, 800), (6, 853), (6, 889), (6, 1016), (6, 1040), (6, 1095), (6, 1137), (6, 1170), (60, 790), (60, 798), (60, 1128), (6221, 1030), (7, 157), (7, 307), (7, 564), (7, 580), (7, 1017), (7, 1030), (7, 1040), (7, 1137), ('7-8-9-10', 1109), (70, 839), ('720p', 330), ('720p', 448), ('720p', 806), ('720p', 852), ('720p', 982), ('720p', 991), (8, 323)[...]

    MySQL output:

    #1062 - Duplicate entry '5-791' for key 1
     
    RosenCruz, Aug 2, 2009 IP
  2. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #2
    That part of the code is already been imported that is the reason u are getting this error
     
    Bohra, Aug 2, 2009 IP
  3. RosenCruz

    RosenCruz Active Member

    Messages:
    489
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    60
    #3
    ok..so i need a clean database.....thanks for the information...
     
    RosenCruz, Aug 3, 2009 IP
  4. mioot

    mioot Peon

    Messages:
    169
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Clear the datas in the new host and then import it again.
     
    mioot, Aug 4, 2009 IP