RE: Two database servers, same physical server

2002-05-06 Thread Luc Foisy
Thanks Don, Gurhan, Peter! uhg. I am sure I searched the docs first. *sigh* -Original Message- From: Don Vu [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:19 PM To: Gurhan Ozen; Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server more detail

RE: Two database servers, same physical server

2002-05-06 Thread Don Vu
more detail on this can be found here http://www.mysql.com/doc/M/u/Multiple_servers.html -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:10 PM To: Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server Hi, To

RE: Two database servers, same physical server

2002-05-06 Thread Peter Lovatt
Hi If the databases are not too big, and are on the same machine, you could just copy the directory with the databases in. If you need to restore the database just copy it back. I think this is OK, though you might want to stop mysql to "lock" the database. I have only done this a couple of ti

RE: Two database servers, same physical server

2002-05-06 Thread Gurhan Ozen
Hi, To run multiple mysqld servers, you at least have to specify a different port number, different socket file path, different pid and error log file to get it started. Different mysqld servers may point to the same database. To do this, just define the necessary information for your new mysql