The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Transfer MySQL DB from server to server!

Discussion in 'General Discussion' started by wimp, Sep 30, 2002.

  1. wimp

    wimp Well-Known Member

    Joined:
    Jul 13, 2002
    Messages:
    301
    Likes Received:
    0
    Trophy Points:
    16
    if i move accounts from server to server ,some accounts create the following error when moving MySQL DB:
    -------------
    Restoring mysql dbs....Done
    Restoring mysql privs....ERROR 1062 at line 1: Duplicate entry 'localhost-accountname\_dbname_domain' for key 1
    ERROR 1062 at line 2: Duplicate entry 'localhost-accountname\_-user_merry' for key 1
    ERROR 1062 at line 3: Duplicate entry 'localhost-accountname\_-user_' for key 1
    ERROR 1062 at line 4: Duplicate entry 'localhost-accountname\_veicoli-user_frank' for key 1
    ERROR 1062 at line 5: Duplicate entry 'localhost-accountname\_xmb1-user_xmb1' for key 1
    ERROR 1062 at line 6: Duplicate entry 'localhost-accountname\_xmb1-accountname' for key 1
    ERROR 1062 at line 7: Duplicate entry 'localhost-user_tom' for key 1
    ERROR 1062 at line 8: Duplicate entry 'localhost-user_xmb1' for key 1
    ---------------

    what's wrong?
    is there a way to fix that error and moving the DB?

    or is there a way to move DB in another way?

    Thanks
     
  2. wimp

    wimp Well-Known Member

    Joined:
    Jul 13, 2002
    Messages:
    301
    Likes Received:
    0
    Trophy Points:
    16
    no ideas how to fix this or another way to move DB to another server?
     
  3. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    Re-add users to there databases and it is fixed.

    cPanel.net Support Ticket Number:
     
  4. tkoweb

    tkoweb Active Member

    Joined:
    Dec 26, 2002
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    Can you elaborate on this process? (re-adding users to dbs) I have users who are still having problems with the newly copied mysql dbs.

    cPanel.net Support Ticket Number:
     
  5. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    Go to MySQL menu, you will find all databases listed with their users.

    Now re-add any user listed to any database listed.

    That should fix it.

    cPanel.net Support Ticket Number:
     
  6. jsteel

    jsteel Well-Known Member

    Joined:
    Jul 4, 2002
    Messages:
    646
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Atlanta, GA
    That error is stating that the users already exist in the mysql on the new server for the specified privileges.

    Did you happen to try copying the account once before and then temrinate it and then try again? That will typically result in the messages you are seeing as the termination doesn't immediately flush mysql.

    If so, you can safely ignore that message. It's just saying it's not restoring those privileges because they already exist.

    cPanel.net Support Ticket Number:
     
  7. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    You can ignore them but with us this resulted in the site not working properly.

    cPanel.net Support Ticket Number:
     
  8. jsteel

    jsteel Well-Known Member

    Joined:
    Jul 4, 2002
    Messages:
    646
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Atlanta, GA
    Arghh.. Hey NNNils, what are you doing responding to a post from almost a year ago. Odds are high that problem isn't around any more. Probabaly shouldn't waste your time on such old posts, unless of course you are also having the problem and needed the old post to resurface.

    cPanel.net Support Ticket Number:
     
  9. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    I had this problem today and therefore did a search.

    I solved the problem my self and I am used to post the solution then, even though this very person may not have this problem now anymore, but others may get it sometime, seems loyal to me...

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page