www.webdeveloper.com
Results 1 to 2 of 2

Thread: Error when importing a database

  1. #1
    Join Date
    Nov 2013
    Posts
    1

    Error when importing a database

    Hi I've got problem importing a database using phpmyadmin, it's supposed to be simple ... yeah right !

    I digress.

    I'm attempting to import a DB from one VB 4.2.2 forum into another, I've created a DB on the destination server clicked on import and navigated to the file on my PC, it gets so far then I get this error :

    Code:
    Error
    
    SQL query:
    
    --  Dumping data for table `access`  INSERT INTO `access` (`userid`, `forumid`, `accessmask`) VALUES (131, 92, 0), (131, 154, 0), (131, 102, 0), (131, 103, 0), (131, 153, 0), (131, 93, 0), (131, 115, 0), (131, 116, 0), (131, 114, 0), (131, 113, 0), (131, 159, 0), (131, 124, 0), (131, 96, 0), (131, 118, 0), (131, 112, 0), (131, 111, 0), (131, 110, 0), (131, 109, 0), (131, 150, 0), (131, 95, 0), (131, 128, 0), (131, 121, 0), (131, 108, 0), (131, 105, 0), (131, 160, 0), (131, 107, 0), (131, 156, 0), (131, 157, 0), (131, 158, 0), (131, 155, 0), (131, 106, 0), (131, 161, 0), (131, 127, 0), (131, 126, 0), (131, 104, 0), (131, 94, 0), (131, 3, 0), (1, 124, 1), (1, 96, 1), (79, 121, 1), (131, 98, 0), (1, 118, 1), (1, 165, 1), (1, 112, 1), (1, 111, 1), (1, 110, 1), (1, 163, 1), (1, 109, 1), (1, 150, 1), (1, 95, 1), (1, 128, 1), (1, 121, 1), (1, 108, 1), (1, 105, 1), (1, 160, 1), (1, 107, 1), (1, 156, 1), (1, 157, 1), (1, 158, 1), (1, 155, 1), (1, 106, 1), (1, 161, 1), (1, 127, 1), (1, 12[.]
    
    MySQL said: Documentation
    #1062  Duplicate entry '131-92' for key 'PRIMARY'
    Can anyone help me out with this ?

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,220
    I'm guessing you have a unique key defined in the target DB across the combined userid and forumid columns, and there is already an entry in there with the values of 131 and 92, respectively. So first thing to do is to confirm that via your database tools, and then decide what you want to have happen when there is such a duplication -- or if it indicates some other problem that you need to address.
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles