accessing database from different hosting

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
speedy33417
Forum Contributor
Posts: 128
Joined: Sun Jul 23, 2006 1:14 pm

accessing database from different hosting

Post by speedy33417 »

I will be transfering my hosting to godaddy. They have multiple domain hosting now and it seems like a good move for me. I already purchased the hosting and it's active. But I'm still hosted with the old company as well.
My godaddy account comes with 25 mysql databases. I'd like to set up a database there and repopulate while still hosted at the old place.

My question might seem silly, but I just want to make sure. Can I log into my database at godaddy from a site hosted with a different company, so I can start working on it and potentially not lose any data?

Thanks.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

Maybe the database has no connection to the outside world. Maybe the accounts are limited to specific locations. Maybe there's afirewall in either direction. So many possibilites. You will have to try it or ask both providers.
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post by Luke »

I would guess no... simply because the majority of shared hosts I've had have not allowed this... but it's definately possible to do.
User avatar
SpecialK
Forum Commoner
Posts: 96
Joined: Mon Sep 18, 2006 3:49 pm

Post by SpecialK »

What about exporting to a local file from the old DB.

Then importing the local file into the new DB?
User avatar
wtf
Forum Contributor
Posts: 331
Joined: Thu Nov 03, 2005 5:27 pm

Post by wtf »

GoDaddy disables several functions that PHP uses. Hopefully it won't affect your code.


viewtopic.php?t=51739&highlight=godaddy
shneoh
Forum Commoner
Posts: 38
Joined: Mon Sep 25, 2006 2:23 am
Location: Malaysia

Post by shneoh »

Suggest a tool for data migration: http://www.webyog.com/en/

Is a really user friendly tool to use! You will like it.

To have remote access, if you can access to the Users DB, allow connection from your IP.
User avatar
speedy33417
Forum Contributor
Posts: 128
Joined: Sun Jul 23, 2006 1:14 pm

Post by speedy33417 »

Just for future reference for others, godaddy does not allow remote access whatsoever. However I have plenty of domains hosted on my hosting account there, so I just had move some files to their server to be localhost again and access the database. It's a little inconvenient, but will do for now.

Thanks for the help.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Godaddy database servers are hosted on named servers, which can be hit from off their networks as long as you are on a Linux hosting account. But that is irrelevent to this question. I think a simple data dump in phpMyAdmin would give you the data from your current database. Then use the .sql file generated by PMA as an import file in your new database.
Post Reply