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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×