List:General Discussion« Previous MessageNext Message »
From:Mark Date:May 7 2009 12:57pm
Subject:RE: Problems After MySql 5.1.34
View as plain text  
Gary wrote:

> Welcome to the hell that is php + apache + mysql. If you upgrade your
> MySql (especially major versions 5.0 => 5.1) you will also need to
> recompile php against the new MySql client libs. We've had very
> limited success trying to get it to work otherwise.

Well, you don't actually have to recompile PHP entirely, of course: just
its extension.

@TS: Other than that, you basically need to recompile *everything* (or its
mysql dynamic libraries) when you upgrade MySQL. This includes Perl, btw;
so you'd need to build DBD:mysql as well (same for Python, etc).

Walter wrote:

> Any (major)upgrade of mysql client requires the dependent subsystem to
> upgrade also. Anything else would be careless since you do not know if the
> interface has changed.

Actually, you *do* know: that's what the changelog is for. :) When C
header changes are made, an upgrade is in order. If not, when upgrading
between minor versions, say, from 5.0.51 -> 5.0.67 (just an example), you
won't need to recompile all system-wide MySQL client extensions. I've done
this many times, without issue: you just need to be absolutely sure no
header changes were made (when in doubt, recompile).

I recently upgraded to 5.1.34 as well; and it was indeed a hell. :) It's
working just fine, but I spent several hours recompiling MySL client
stuff; without doing so, your apps will likely behave erratically, or just
segfault altogether.

This isn't a MySL hell exclusively, btw. You'll get the same issue
upgrading PostgreSQL, or BerkeleyDB, etc. It's just the nature of the

- Mark

Problems After MySql 5.1.34Johnny Stork6 May
  • Re: Problems After MySql 5.1.34Johnny Stork6 May
    • RE: Problems After MySql 5.1.34Gary Smith6 May
      • Re: Problems After MySql 5.1.34walter harms7 May
        • RE: Problems After MySql 5.1.34Mark7 May
          • RE: Problems After MySql 5.1.34Gary Smith7 May
            • Re: Problems After MySql 5.1.34 - THANKSJohnny Stork9 May
    • Re: Problems After MySql 5.1.34Joerg Bruehe7 May
  • Re: Problems After MySql 5.1.34Joerg Bruehe7 May
    • RE: Problems After MySql 5.1.34Gary Smith7 May
RE: Problems After MySql 5.1.34Mark7 May