Re: Running 2 versions of MySQL on same server

2008-07-03 Thread Curtis Maurand
Which *n?x distribution are you running? [EMAIL PROTECTED] wrote: No, because I fear that would break the existing customer php apps, which is the whole point of running two versions of MySQL. What I guess I need to know is if php's mysql and mysqli extensions can be made to recognize

Re: Running 2 versions of MySQL on same server

2008-07-03 Thread up
FreeBSD 6.2-STABLE On Thu, 3 Jul 2008, Curtis Maurand wrote: Which *n?x distribution are you running? [EMAIL PROTECTED] wrote: No, because I fear that would break the existing customer php apps, which is the whole point of running two versions of MySQL. What I guess I need to know is

Re: Running 2 versions of MySQL on same server

2008-07-02 Thread up
It would appear that the problem isn't getting MySQL 3.23 and 5.0 to run on the same server with different ports and sockets, but rather getting mod_php to recognize both clients. phpinfo() shows only 3.23, since it's in the standard path. If anyone has experience getting two different

Re: Running 2 versions of MySQL on same server

2008-07-02 Thread Curtis Maurand
Did you rebuild php against the 5.0 libraries as I suggested yesterday? If you didn't it will only recognize the 3.23 version. It will not be able to talk to the 5.0 version. Curtis [EMAIL PROTECTED] wrote: It would appear that the problem isn't getting MySQL 3.23 and 5.0 to run on the

Re: Running 2 versions of MySQL on same server

2008-07-02 Thread up
No, because I fear that would break the existing customer php apps, which is the whole point of running two versions of MySQL. What I guess I need to know is if php's mysql and mysqli extensions can be made to recognize two different sets of client libs. Unless you're telling me that

Running 2 versions of MySQL on same server

2008-07-01 Thread up
Hi: I've been running 3.23 for years, but several users are clamoring for new versions, as many php apps are using newer features, so I downloaded the source for 5.0.51b to run on a different TCP port. I found a reference on a couple of ways to do this here:

Re: Running 2 versions of MySQL on same server

2008-07-01 Thread Kevin F. O'Riordan
Hi James, If I telnet to port 3306, I get the old version as I should and when I telnet to the new port I get the new version as I should, but if I do a: mysqladmin -P (new port) variables I get the old variables. I'd suspect mysqladmin's using the unix socket, and ignoring your -P

Re: Running 2 versions of MySQL on same server

2008-07-01 Thread up
On Tue, 1 Jul 2008, Kevin F. O'Riordan wrote: Hi James, If I telnet to port 3306, I get the old version as I should and when I telnet to the new port I get the new version as I should, but if I do a: mysqladmin -P (new port) variables I get the old variables. I'd suspect mysqladmin's

Re: Running 2 versions of MySQL on same server

2008-07-01 Thread up
On Tue, 1 Jul 2008, [EMAIL PROTECTED] wrote: I would think this would be a relatively simple thing to do. I guess I'm going to try to build MySQL with the config options instead of invoking at runtime...both versions seem hopelessly confused. Well, I rebuilt and installed 5.0 again using