Jump to content
Sign in to follow this  
Samrc

Move Mysql Database From A Webos To Cpanel

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...