MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:David (SST - Adelaide) Logan Date:February 17 2005 2:04am
Subject:RE: Using Different Database Groups On the Same Computer
View as plain text  
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-mysql aliases to a mysql command with either a different
port number or hostname to access the newer version whereas the mysql
would point to localhost on the standard port.

I run 2 different versions on one of my smaller linux boxes for
precisely the reason you are talking about. If you are accessing these
via php for example, you can use an environment variable to set which
port, host etc. you wish to talk to.

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-----
From: Hal Vaughan [mailto:hal@stripped] 
Sent: Thursday, 17 February 2005 12:23 PM
To: mysql@stripped
Subject: Using Different Database Groups On the Same Computer

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 newer version
of my 
program on a new computer.  I'd like to have both versions (current and
new) 
on the same computer, however, that will cause a LOT of problems in 
interference between the current and development versions of my program.

Is there any way to separate these, so I can run mysql one way to access
the 
databases for the current version, and run it another way to access the
newer 
databases for the development version (and yes, many databases in the 
development version will have the same name as those in the current
version).

For example, if I ran a command "mysql", I'd get these tables:

CaseData
Clients
GeneralSetup

And if I ran an alias, like, say, "new-mysql", I'd get these tables:

CaseData  (same name, different table)
Clients  (same name, different table)
GeneralSetup  (same name, different table)
DataFilters

I am running MySQL on Linux, if that makes a difference.

Hal

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
  • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
    • Re: Using Different Database Groups On the Same ComputerHassan Schroeder17 Feb
      • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
        • Re: Using Different Database Groups On the Same ComputerHassan Schroeder17 Feb
          • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
            • Re: Using Different Database Groups On the Same ComputerHassan Schroeder17 Feb
              • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
        • Re: Using Different Database Groups On the Same ComputerKristen G. Thorson17 Feb
RE: Using Different Database Groups On the Same ComputerSST - Adelaide)17 Feb
  • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
RE: Using Different Database Groups On the Same ComputerSST - Adelaide)17 Feb
  • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
RE: Using Different Database Groups On the Same ComputerSST - Adelaide)17 Feb
  • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb