Is it possible for a remote server or even another account on the same server to access the MySQL Database of an account?
The reason I ask this is a I have a client who wants to set-up a second website but wants to pull a lot of the data from his existing website which is in a MySQL Database.
How would I go about doing this?
Connecting to remote MySQL Database with CPanel
Moderator: General Moderators
Re: Connecting to remote MySQL Database with CPanel
You will need a database migration tool to do such a task or do it the easier way.Go to phpmyadmin and export everything to a text file,then take the text file and dump it into your new website.
For the part of database migration tools,swiss sql has plenty but i have not yet researched on mysql,check it out,you might find something useful.
For the part of database migration tools,swiss sql has plenty but i have not yet researched on mysql,check it out,you might find something useful.
Re: Connecting to remote MySQL Database with CPanel
This is basically a permissions problem. If you have the right permissions you can set him another database and allow his account to access both.