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:[EMAIL PROTECTED] Sent: Thursday, 17 February 2005 12:23 PM To: mysql@lists.mysql.com 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]