High, as you can tell from the review i wrote about 1&1, i really really dont want to move, but im fed up with the measly 1 mysql database they offer. Could anyone please reccomend me a free host which has mysql databases? ive been looking, but i cant find any at the moment. all i would really like is the hostname for the databse and the username and password, this way i can keep my account with 1&1 and use the free database remotely.
A free hosting with mysql...There are a few, but the downside is, they are slow, each query has to be sent to a remote server and back, they slow down your site alot...Why not just use table prefixes....
well....at current i have 466 tables in my database. i do use prefixes, but with so many tables it just gets TOO messy and when goin manually into the database (by manually i mean through phpmyadmin) its a nightmare gettin down to the right table.
Also, if i use a php script from the internet, a lot of them don't use prefixes, so i end up scripts overwriting tables that were made by other scripts. its just too messy. Plus the fact that my site uses php nuke, and nuke uses LOADS of table anyway, i woudl just really prefer more then one database.
is it possible to have mysql, php, asp and mssql/access database on one server? or am i just being stupid? lol
Make sure that the cheap packages you are looking at allow remote access for MySQL.
Another issue to be concerned about is your bandwidth at the cheap host. If you have over 400 tables in a database I would guess that you use quite a few database driven applications, every access to the MySQL server is transfer that will be counted on your cheap host bandwidth allocation.
My advice is find a host that will give you a more generous amount of MySQL databases and move everything over to them...
i don't know if they are any good though. does anybody have any experience with them?
you can only create databases through their signup form and not through phpmyadmin, but from what i understand you can sign up as many times as you want...i think anyway.
i haven't had any time to test them properly, i have tried them remotely and they do work, but i want to see how fast it is but i dont want to put any live script on my site using them, just incase they arent that fast or they mess up or you know, anything else like that.
anyway, just want to know if anyone knows about their capabilities?
if not, then yeah, i'll just go for paid hosting...oh yeah, does anyone know of any mysql specific hosts? for example, someone offereing remote mysql databases to buy> rahter than a complete hosting package.