New Database Offerings
Categories: Shared Hosting,Linux Shared Hosting,Windows Shared Hosting,Hosting
Take a look at our two new database offerings...
Direct Database Access
You now have access to remotely manage your hosting account databases with external tools. For those looking to use this new feature, the 'Allow Direct Database Access' option will need to be enabled upon set up.
In order to provide the best experience, customers using direct database access are required to be located in our newest hosting environment. For our existing customers, we're in the process of creating a mechanism for you to have your account moved to the new environment. If you have databases, you may choose to use the existing MySQL/SQL Server backup tool to save your content before removing that database and enabling direct database access.
For additional articles look here.
Can I connect to my database remotely?
Even with increased functionality because of this offering, it is also a less secure way to manage your databases.
Unlimited Databases
Our new unlimited hosting plan now includes unlimited databases.
Setting up a MySQL Database for Your Web Site
Setting up a SQL Server Database on Your Hosting Account
Can't we enable this facility for existing MSSql Databases? Or what we need to do for existing databases.
Reply to this
Is there a limit to the size of database (say 200 MB each) or is that also unlimited?
Reply to this
MySQL databases are limited to 200 MB each.
MySQL Database Limits
Reply to this
I just setup a SQL database and did not see this option. I need to be in the new environment and don't know how to get there! Help Godaddy!
Reply to this
You will need to perform a back up database(s). Than you will need to remove the database(s) and recreate it to allow direct database access.
Reply to this
I have created a DB twice in the last few days (late February), so I should be in the "new" environment, but do not see an option anywhere to enable Direct Access. Suggestions? Backup, delete and restore anyway? I actually will try that.
Reply to this
There is not an option to enable as of yet. You're correct, you'll have to backup, create a new database and restore.
Reply to this
I had the same problem Casey did when creating a new MySQL db. Are you saying that after deleting a backed up db, creating a new one with the same name will enable the 'Allow Direct Database Access' option? Can the new db be restored from the original at this point?
Reply to this
The remote database is prefect for new developers just getting started. You can use the same connection string in your local environment that you do in production! A little less secure but absolutely unbeatable for the beginning developer. Imagine using the configure website button on your laptop and your configuring your godaddy website.
Note: Its less secure. I personally don't have any remote configured databases.
Good Luck
Reply to this
I have set up SQL databases several times via goDaddy and made sure that I have remote connections allowed in the options of the webpage... Once it's setup, I can't connect from MS SQL Server Management Studio though. This is getting annoying now.... Any tips/ideas??
Reply to this
thanks to godaddy, it makes my work easy.
from my heart, i am sending my thanks for all their care and good support
regards
satya
Reply to this
So nice to hear this! Thanks for stopping in and sharing your comments!
Reply to this
Hi Alicia
I don't get this option when I create a new database, why is that so?
Reply to this
You'll need to enable SSH so that your account is moved to our newest hosting environment. This will allow for you to enable direct database access.
Reply to this
Could you tell me how to addMS SQL server 2000 database!Only sql server 2005? if no! tell me how to up it, plz. Thanks!
Reply to this
All new databases created are in MSSQL 2005 format. MSSQL 2005 is backward compatible with MSSQL 2000. We do not support an automated upgrade from version 2000 databases to version 2005 databases.
Reply to this
I was given the task this week to move our account from GoDaddy to another provider because your technical support agent confirmed that GoDaddy does not support Direct DB Access. Luckily, I found this thread before making the move. I think you should ensure that your technical support team is aware of this feature.
By the way, can we limit the Direct DB Access to a specific IP or a whitelist of IP addresses?
Reply to this
You can not limit the Direct DB Access to a specific IP or a whitelist of IP addresses.
Reply to this
Hi - do you have more details about how the 200MB mySQL limit is calculated? I ask because I have a database which is *very* close to 200MB, and depending on how you measure an "MB", it might or might not go over the limit. (e.g. is 1MB = 1024*1024, 1000*1024, or 1000*1000?)
Also, where is the limit enforced? Will MySQL simply fail SQL calls which would cause the DB to grow beyond 200MB, or is the enforcement after the fact (e.g. shutting down DBs which grow too large)? I'm asking because I want to be able to know in my staging environment that I've gotten too large, without risking failure on my production site.
BTW, some feedback for you: I would gladly pay a few $$$ more per month to allow larger databases (e.g. 500M
Reply to this