Transfer MySQL DB from server to server!

[wimp]

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

 

[wimp]

no ideas how to fix this or another way to move DB to another server?

 

[NNNils]

Re-add users to there databases and it is fixed.

cPanel.net Support Ticket Number:

 

[tkoweb]

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:

 

[NNNils]

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:

 

[jsteel]

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:

 

[NNNils]

You can ignore them but with us this resulted in the site not working properly.

cPanel.net Support Ticket Number:

 

[jsteel]

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:

 

[NNNils]

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: