Page 1 of 1

accessing database from different hosting

Posted: Thu Sep 28, 2006 2:01 pm
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.

Posted: Thu Sep 28, 2006 2:47 pm
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.

Posted: Thu Sep 28, 2006 3:04 pm
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.

Posted: Thu Sep 28, 2006 4:04 pm
by SpecialK
What about exporting to a local file from the old DB.

Then importing the local file into the new DB?

Posted: Thu Sep 28, 2006 4:13 pm
by wtf
GoDaddy disables several functions that PHP uses. Hopefully it won't affect your code.


viewtopic.php?t=51739&highlight=godaddy

Posted: Thu Sep 28, 2006 10:27 pm
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.

Posted: Fri Sep 29, 2006 6:13 am
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.

Posted: Fri Oct 06, 2006 12:48 am
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.