Jump to content


Photo

Move Mysql Database From A Webos To Cpanel


  • Please log in to reply
1 reply to this topic

#1 Samrc

Samrc

    Immediate Family

  • Members
  • PipPipPipPip
  • 1,336 posts

Posted 27 February 2012 - 09:54 AM

A friend is moving a mySql database from a server with WebOS to a server with cPanel.
I have been trying to help research the problem with her and having no luck.
Both servers have PHP admin, and export of the database has been transfered to the new server.

But the mySql USER NAME conventions for the servers are totally different.
The file fails to import because the new username does not have permissions to use this database.
The user naming at old server is abcde12345
The user naming at the new server is azqtlp_12345 where the azqtlp is always the user name of the hosted account followed by underscore.
And of course the user name on the hosted account is not the same on both servers
She tried to create a user azqtlp_12345 on the old server and it will not allow that.
She tried to create a user abcde12345 on the new server and again no joy.

SO... how the heck do you get import and use the database on the new server???
Can someone point me to a solution for this?

By the way, I tried to get her to come to TCH but she is just combining her sites on one host now - two sites, one account without reseller package.
Samantha
SamiSite.com CSB and WYSIWYG program tutorials
Feel free to right click the silly little forum images I use and save them to your own website space.
Then link to your own site. Please don't hotlink to my website to use the images. Thanks!

#2 TCH-Bruce

TCH-Bruce

    Volunteer Moderator

  • Members
  • PipPipPipPip
  • 19,960 posts

Posted 27 February 2012 - 06:22 PM

You need to edit the exported file and put the current database name and user name into it I believe.

Bruce Richards
Forum Moderator
TotalChoice Hosting, Inc.
Webhosting by Total Choice Web Hosting - General Support Forum

I am a Forum Moderator. While I can assist in answering most of your hosting related questions, I am unable to answer questions about specifics relating to your account such as billing and server related issues. Should you need assistance in these areas, please contact our Help Desk or our many other options. Another good place to find answers is with our help pages, tutorials and movie tutorials.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users