Topic awaiting preservation: Beginer in web based system (Page 1 of 1)

Anybody home...Plzzz help me.....

I got a PHP web page which is running on Linux Web Server...The Database also in that server...
My Boss ask me to put the database in a NT server but the web server is still the same...
Let say...If i want to do that...is it possible...???If yes...How to make the connection between my web and database??

Thanks

Live Your Life

rangga: Welcome. I'll move this over to the server-side scripting forum where it is more at home

To answer your question(s):

1. Yes you can run MySQL on a Windows box (see the FAQ on installing AMP).

2. Yes you can connect to a remote version of MySQL (there was a service a while back which offered to host a MySQL DB for free).

I'm not sure its overly wise working like this but if you had to do it then it is doable.

___________________
Emps

FAQs: Emperor

Emps: It's fairly common among those companies that don't use an outside commercial hosting service. The advantage is that it isolates the database from the web server thereby increasing security since the database box sits behind the firewall.

Further it increases safety since a webserver crash doesn't affect the database. Err, wait a minute. Rangga is moving the database to a Windows box, so that would should be rephrased: When Windows crashes it won't take down the web server.

Finally it can improve performance by distributing the load. This is especially helpful when running reports (like periodic sales and accounting reports) from the database since doing so will not slow down the web server.

Rangga: Making the connection between the two is easy. The database server location is somewhere in your web application's configuration. (Every application is different, sorry I can't be more specific.) Right now it probably says "localhost" or 127.0.0.1. Change that to the IP address of the database server, and change any logins and passwords accordingly.

edit: Whoopsie. Typos.



[This message has been edited by brucew (edited 08-28-2003).]

well, actually, if she had a local mysql so far, it should say something like ':/var/mysql/mysld.sock' - unix sockets being much faster than tcp/ip ones even to localhost...

TP: Tell me more about UNIX sockets. I'm not familiar with it at all.