Hi I am not that clever with databases, I was wondering if I could use a database on another host and link my website from the host I have now to that database? if so can this make any problems? The host I use is OK and I have been with them along time but they only have 100mb databases, and i want a bigger one, if this can be done can any one recommend a cheap host that is trusting and reliable with a good size mysql database offer?
Yes, the function to connect to database in server side languages has a parameter for the host, so instead of "localhost" (database on same server), you would use the other website's URL/IP for the host.
Thank you, I am looking for a low cost host now to give this a try and see if it works out better for me in the long run
Many (most?) hosts don't allow access to their database servers from external machines. They only allow access from localhost (ie. the same machine the site is on) or from known hosts inside their network. This is a security precaution to prevent hackers from trying to illegally access a database server. Just be sure the chosen host allows external database access before you signup.
The server , where you upload your website, if allow to make the connection with the other database server, then only you can use the data base on other servers, otherwise not. Yea try to find some others, like try this one, as i am also using this for my website. hostexcellence cheers
mySQL connection is not encrypted, make sure the provider or yourself can provide/setup SSL connection to the database.