Re: Two instances of MySQL

2008-04-06 Thread Moon's Father
You can read more at my blog, if you want . On Tue, Apr 1, 2008 at 8:55 PM, Kaushal Shriyan [EMAIL PROTECTED] wrote: Hi I am referring to http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html to create multiple instances of MySQL Database Server. I wanted it for Gentoo Linux

Two instances of MySQL

2008-04-01 Thread Kaushal Shriyan
Hi I am referring to http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html to create multiple instances of MySQL Database Server. I wanted it for Gentoo Linux is there a HowTo for configuring multiple instance of MySQL Database Server on Gentoo Linux Thanks and Regards Kaushal --

Re: Two Instances

2004-10-26 Thread Egor Egorov
Christopher Chamber [EMAIL PROTECTED] wrote: Hi Everyone. My problem is that i want to create 2 instances of a sub-query. For Example: SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name = 'reviews' AND v2.sal = v1.sal ) v3 , v4 This query will gives an error as V4

Two Instances

2004-10-25 Thread Christopher Chamber
Hi Everyone. My problem is that i want to create 2 instances of a sub-query. For Example: SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name = 'reviews' AND v2.sal = v1.sal ) v3 , v4 This query will gives an error as V4 is not allowed, i.e. not more than 1 instance of a

Two Instances

2004-09-06 Thread Rahul Thathoo
Hi Everyone. My problem is that i want to create 2 instances of a sub-query. For Example: SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name = 'reviews' AND v2.sal = v1.sal ) v3 , v4 This query will gives an error as V4 is not allowed, i.e. not more than 1 instance of a

my.ini file for two instances of MySql - need help

2004-01-12 Thread Rich Brant
Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add

Re: my.ini file for two instances of MySql - need help

2004-01-12 Thread Paul DuBois
At 16:48 + 1/12/04, Rich Brant wrote: Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both

RE: my.ini file for two instances of MySql - need help

2004-01-12 Thread Chris L. White
AM To: [EMAIL PROTECTED] Subject: my.ini file for two instances of MySql - need help Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need

RE: my.ini file for two instances of MySql - need help

2004-01-12 Thread Rich Brant
] To: 'Rich Brant' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: my.ini file for two instances of MySql - need help Date: Mon, 12 Jan 2004 10:55:21 -0600 Here is an example of what I used: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data

RE: my.ini file for two instances of MySql - need help

2004-01-12 Thread Tobias Asplund
Hello, What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? I install with mysqld-nt-max --install servicename servicename in those cases are MysQL40, MySQL41 and MySQL50 Those are the relevant rows: [mysqld] [mysql40] basedir =

Re: my.ini file for two instances of MySql - need help

2004-01-12 Thread robert_rowe
# If you specify no service name, the server uses the default service name of MySQL and the server reads options from the [mysqld] group in the standard option files. # If you specify a service name after the --install option, the server ignores the [mysqld] option group and instead reads

RE: my.ini file for two instances of MySql - need help

2004-01-12 Thread Rich Brant
Ok, Thanks Tobias! I'm all set. And I actually found the relevant info in the manual. Sorry for the bother, all. From: Tobias Asplund [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: 'Rich Brant' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: my.ini file for two instances of MySql

Running two instances from one my.ini?

2002-08-20 Thread Elliot Smith
Hello, I have mysqld-max (3.23.51) running on a Windows 2000 machine. Is it possible to run another MySQL server alongside it, using the same my.ini file but set on a different port, e.g. with mysqld-max --standalone --console --port=3307 The reason I want to do this is to check

RE: setting up two instances of mySQL

2002-06-13 Thread Francisco Reinaldo
* http://www.calevans.com * -Original Message- From: Chris Stefanick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 7:56 AM To: MySQL Support Subject: setting up two instances of mySQL I have one product already using a mySQL database. We just inherited a new

Re: setting up two instances of mySQL

2002-06-13 Thread Joshua Horton
-Mage * http://www.calevans.com * -Original Message- From: Chris Stefanick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 7:56 AM To: MySQL Support Subject: setting up two instances of mySQL I have one product already using a mySQL database. We just

RE: setting up two instances of mySQL

2002-06-13 Thread Mark.Andrachek
: Subject:RE: setting up two instances of mySQL Hi Chris, I am Tom, you know your manager, did you say that I am wrong!!! Just kidding :-). Well I cannot find any good reason for having two databases in two different instance. Do you have two Oracles or Microsoft SQL Server

setting up two instances of mySQL

2002-06-05 Thread Chris Stefanick
I have one product already using a mySQL database. We just inherited a new product (via an acquisition) that uses it's own mySQL database which we're going to stick on the same server. My manager wants me to setup a second instance of mySQL on the machine for the new product's database. I

RE: setting up two instances of mySQL

2002-06-05 Thread Cal Evans
Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Chris Stefanick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 7:56 AM To: MySQL Support Subject: setting up two instances of mySQL I have one product already using a mySQL database. We just inherited a new

Re: setting up two instances of mySQL

2002-06-05 Thread Egor Egorov
Chris, Wednesday, June 05, 2002, 3:55:52 PM, you wrote: CS I have one product already using a mySQL database. We just inherited a new CS product (via an acquisition) that uses it's own mySQL database which we're CS going to stick on the same server. My manager wants me to setup a second CS

Re: setting up two instances of mySQL

2002-06-05 Thread Mark
- Original Message - From: Chris Stefanick [EMAIL PROTECTED] To: MySQL Support [EMAIL PROTECTED] Sent: Wednesday, June 05, 2002 2:55 PM Subject: setting up two instances of mySQL I have one product already using a mySQL database. We just inherited a new product (via an acquisition