Connecting to remote MySQL Database with CPanel

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Mr Tech
Forum Contributor
Posts: 424
Joined: Tue Aug 10, 2004 3:08 am

Connecting to remote MySQL Database with CPanel

Post 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?
User avatar
phpserver
Forum Newbie
Posts: 22
Joined: Mon Oct 20, 2008 2:59 am
Location: Eastleigh,Nairobi

Re: Connecting to remote MySQL Database with CPanel

Post 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.
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Connecting to remote MySQL Database with CPanel

Post 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.
Post Reply