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.
accessing database from different hosting
Moderator: General Moderators
- speedy33417
- Forum Contributor
- Posts: 128
- Joined: Sun Jul 23, 2006 1:14 pm
GoDaddy disables several functions that PHP uses. Hopefully it won't affect your code.
viewtopic.php?t=51739&highlight=godaddy
viewtopic.php?t=51739&highlight=godaddy
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.
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.
- speedy33417
- Forum Contributor
- Posts: 128
- Joined: Sun Jul 23, 2006 1:14 pm
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.
Thanks for the help.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
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.