Re: Running 2 versions of MySQL on same server

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 cust

Re: Running 2 versions of MySQL on same server

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 using

"ONLY IN"

Possible duplicate, sorry if so. Schema below. I am trying to select from a many-to-many relationship all edition_ids that have records for, and only for, certain run_id values. I have no idea how to do this outside of a subquery, which I'd rather avoid. Any thoughts? Here's what I have now,

Re: Running 2 versions of MySQL on same server

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 "-

Re: Queues on MySQL?

>>Thanks for the suggestion--is that essentially using >>http://www.php.net/posix_mkfifo within PHP? >> > [JS] Yes, that's what I had in mind. Be warned, though: I've never used this > from PHP; and, although I found no references to this in the PHP > documentation, I couldn't find the POSIX functi

Running 2 versions of MySQL on same server

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: http://dev.mysql.com/doc/refman/

Merge-table Question

Hello, I remember some activity regarding some flakiness when using merge-tables. I searched out and reviewed this: http://bugs.mysql.com/bug.php?id=26881 Using 5.0.51a on RHEL 4 box, I'm still seeing similar issues. The INFORMATION_SCHEMA shows the merge table as follows TABLE_CATALOG: NUL

RE: force row to appear at top of results using order by

>-Original Message- >From: Andrew Martin [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 01, 2008 9:20 AM >To: mysql@lists.mysql.com >Subject: force row to appear at top of results using order by > >Hello, > >I have an order by question... > >This is the "raw" data... > >mysql> SELECT events

RE: force row to appear at top of results using order by

SELECT events_groups_id, events_groups_name FROM events_groups ORDER BY IF(events_groups_id=1,0,1),events_groups_name ASC; -Original Message- From: Andrew Martin [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:20 AM To: mysql@lists.mysql.com Subject: force row to appear at top of

Re: force row to appear at top of results using order by

Many thanks for the quick replies! This solution appears the most elegant: -- Forwarded message -- From: Markus Grossrieder <[EMAIL PROTECTED]> Date: 2008/7/1 Subject: Re: force row to appear at top of results using order by To: Andrew Martin <[EMAIL PROTECTED]> Andrew, somethi

RE: Queues on MySQL?

>-Original Message- >From: Waynn Lue [mailto:[EMAIL PROTECTED] >Sent: Monday, June 30, 2008 8:01 PM >To: Jerry Schwartz >Cc: MySQL List >Subject: Re: Queues on MySQL? > >Thanks for the suggestion--is that essentially using >http://www.php.net/posix_mkfifo within PHP? > [JS] Yes, that's what

force row to appear at top of results using order by

Hello, I have an order by question... This is the "raw" data... mysql> SELECT events_groups_id, events_groups_name FROM events_groups; +--+-+ | events_groups_id | events_groups_name | +--+-+ |1 | Personal Ev

Re: Problem with CREATE TABLE/DROP TABLE

On Jun 24, 2008, at 2:57 AM, Gwynne Raskind wrote: I'm having the issue with CREATE TABLE described by Bug #30513 (http://bugs.mysql.com/bug.php?id=30513 ). To summarize, a table which previously existed, and then is dropped by DROP TABLE IF EXISTS, becomes randomly unable to be recreated. He