Re: Using Different Database Groups On the Same Computer

2005-02-17 Thread Hal Vaughan
On Thursday 17 February 2005 11:48 am, Hassan Schroeder wrote: > Hal Vaughan wrote: > > mysqld --port=3307 --datadir=/dbtest/mysql > > mysqld --port=3306 --datadir=/var/lib/mysql > > mysql --port=3307 > > mysql --port=3306 > > > > When I do this, then do a "show databases;" in either new instance o

Re: Using Different Database Groups On the Same Computer

2005-02-17 Thread Hassan Schroeder
Hal Vaughan wrote: mysqld --port=3307 --datadir=/dbtest/mysql mysqld --port=3306 --datadir=/var/lib/mysql mysql --port=3307 mysql --port=3306 When I do this, then do a "show databases;" in either new instance of mysql (both are open at the same time, in separate consoles), I get the databases in

Re: Using Different Database Groups On the Same Computer

2005-02-17 Thread Hal Vaughan
On Thursday 17 February 2005 10:56 am, Hassan Schroeder wrote: > Hal Vaughan wrote: > > I see that, but even when I bypass them, I can run 2 instances of mysqld, > > it shows up in the task list as 2 separate tasks, but they both use the > > data directory specified in the last instance I run. > >

Re: Using Different Database Groups On the Same Computer

2005-02-17 Thread Kristen G. Thorson
http://dev.mysql.com/doc/mysql/en/multiple-unix-servers.html There may be some helpful notes there. How are you determining which datadir mysqld is using when it's actually running? Are you logging in with mysql or mysqladmin? Make sure that if you are doing so, that you're actually logging i

Re: Using Different Database Groups On the Same Computer

2005-02-17 Thread Hassan Schroeder
Hal Vaughan wrote: I see that, but even when I bypass them, I can run 2 instances of mysqld, it shows up in the task list as 2 separate tasks, but they both use the data directory specified in the last instance I run. Uh, that doesn't really make sense -- a *running* instance isn't going to switc

Re: Using Different Database Groups On the Same Computer

2005-02-17 Thread Hal Vaughan
On Thursday 17 February 2005 10:18 am, Hassan Schroeder wrote: > Hal Vaughan wrote: > > I've tried this by running 2 instances of mysqld, the first with no > > arguments, and the second like this: > > > > mysqld --port=3307 --datadir=/dbtest/mysql > > > > I have to run mysqld directly -- not throug

Re: Using Different Database Groups On the Same Computer

2005-02-17 Thread Hassan Schroeder
Hal Vaughan wrote: I've tried this by running 2 instances of mysqld, the first with no arguments, and the second like this: mysqld --port=3307 --datadir=/dbtest/mysql I have to run mysqld directly -- not through safe_mysqld (which /etc/init.d/mysql calls). If I run it through safe_mysqld, I can

Re: Using Different Database Groups On the Same Computer

2005-02-16 Thread Hal Vaughan
On Wednesday 16 February 2005 08:52 pm, Hal Vaughan wrote: > I'm not quite sure what search terms to use, otherwise I'm sure I could > find this on Google. > > I have a working install of MySQL on an older computer, running the current > version of my program.  I am about to start developing a newe

Re: Using Different Database Groups On the Same Computer

2005-02-16 Thread Hal Vaughan
; +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -Original Message- > From: Hal Vaughan [mailto:[EMAIL PROTECTED] > Sent: Thursday, 17 February 2005 1:10 PM > To: mysql@lists.mysql.com > Subject: Re: Using Different Database Groups

RE: Using Different Database Groups On the Same Computer

2005-02-16 Thread Logan, David (SST - Adelaide)
obile +61 8 8408 4259 - Fax -Original Message- From: Hal Vaughan [mailto:[EMAIL PROTECTED] Sent: Thursday, 17 February 2005 1:10 PM To: mysql@lists.mysql.com Subject: Re: Using Different Database Groups On the Same Computer On Wednesday 16 February 2005 09:27 pm, Logan, David (SST - Ade

Re: Using Different Database Groups On the Same Computer

2005-02-16 Thread Hal Vaughan
x27;s a big help! Hal > Regards > > David Logan > Database Administrator > HP Managed Services > 148 Frome Street, > Adelaide 5000 > Australia > > +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -Original Message-

RE: Using Different Database Groups On the Same Computer

2005-02-16 Thread Logan, David (SST - Adelaide)
ROTECTED] Sent: Thursday, 17 February 2005 12:45 PM To: Logan, David (SST - Adelaide) Subject: Re: Using Different Database Groups On the Same Computer On Wednesday 16 February 2005 09:04 pm, you wrote: > Hi Hal, > > Do you mean using the same version but accessing 2 different set

Re: Using Different Database Groups On the Same Computer

2005-02-16 Thread Hal Vaughan
On Wednesday 16 February 2005 09:04 pm, you wrote: > Hi Hal, > > Do you mean using the same version but accessing 2 different sets of > tables? I'm a little confused as to what your requirements are. Or databases.  Basically, I want it all on one system, but I don't want the current databases, wh

RE: Using Different Database Groups On the Same Computer

2005-02-16 Thread Logan, David (SST - Adelaide)
Hi Hal, Do you mean using the same version but accessing 2 different sets of tables? I'm a little confused as to what your requirements are. You could install both versions and use aliases to ensure that you can access only one instance at a time by the method you described. You would have new-my