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
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
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.
>
>
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
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
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
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
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
; +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
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
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-
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
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
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
14 matches
Mail list logo