Page 1 of 1

Connecting to remote MySQL Database with CPanel

Posted: Wed Dec 10, 2008 7:30 pm
by Mr Tech
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?

Re: Connecting to remote MySQL Database with CPanel

Posted: Sun Dec 14, 2008 4:36 am
by phpserver
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.

Re: Connecting to remote MySQL Database with CPanel

Posted: Sun Dec 14, 2008 5:54 am
by Eran
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.