From owner-freebsd-questions@FreeBSD.ORG Tue Jun 7 13:26:04 2011 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E69C81065672 for ; Tue, 7 Jun 2011 13:26:04 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3fd3:cd67:fafa:3d78]) by mx1.freebsd.org (Postfix) with ESMTP id 50BF08FC16 for ; Tue, 7 Jun 2011 13:26:04 +0000 (UTC) Received: from russet.local (reflex.squiz.co.uk [83.217.109.164]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.5/8.14.5) with ESMTP id p57DPhP1008840 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO) for ; Tue, 7 Jun 2011 14:26:00 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.8.3 smtp.infracaninophile.co.uk p57DPhP1008840 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1307453160; bh=DfdiBhlwE6/k8iEsOnBi9ueH3DXneB0TQcMvekFSIXQ=; h=Message-ID:Date:From:MIME-Version:To:Subject:References: In-Reply-To:Content-Type:Cc:Content-Type:Date:From:In-Reply-To: Message-ID:Mime-Version:References:To; z=Message-ID:=20<4DEE26D0.4030208@infracaninophile.co.uk>|Date:=20T ue,=2007=20Jun=202011=2014:25:36=20+0100|From:=20Matthew=20Seaman= 20|User-Agent:=20Mozilla/5.0=20(M acintosh=3B=20U=3B=20Intel=20Mac=20OS=20X=2010.6=3B=20en-US=3B=20r v:1.9.2.17)=20Gecko/20110414=20Thunderbird/3.1.10|MIME-Version:=20 1.0|To:=20freebsd-questions@freebsd.org|Subject:=20Re:=20MySQL=20u pdate|References:=20<7E6F915F8DE848FEABB9A0F4A901062E@GLENN2>=20|In-Reply-To:=20 |X-Enigmail-Ve rsion:=201.1.1|Content-Type:=20multipart/signed=3B=20micalg=3Dpgp- sha1=3B=0D=0A=20protocol=3D"application/pgp-signature"=3B=0D=0A=20 boundary=3D"------------enig02D70ABEC1FAB52D7C2E7167"; b=wvUX4Zz7TztWofeEtp3DSTP+m5QgM6CQeE3VL6KWcMB8K2tQ5G3Jvg4HRJo/iHBMM eGu07xGqEd9oBBz3ZYBAG409iyj6MFHNMyLPeP3Pdb3fi9O2RI49Gvl4CWc9wO7j3W aFUQMYK9oc6ciQvMywtC29xyZ3saA68vTOuKVZPI= X-Authentication-Warning: lucid-nonsense.infracaninophile.co.uk: Host reflex.squiz.co.uk [83.217.109.164] claimed to be russet.local Message-ID: <4DEE26D0.4030208@infracaninophile.co.uk> Date: Tue, 07 Jun 2011 14:25:36 +0100 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10 MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: <7E6F915F8DE848FEABB9A0F4A901062E@GLENN2> In-Reply-To: X-Enigmail-Version: 1.1.1 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig02D70ABEC1FAB52D7C2E7167" X-Virus-Scanned: clamav-milter 0.97 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-0.1 required=5.0 tests=BAYES_40,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,SPF_FAIL autolearn=no version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on lucid-nonsense.infracaninophile.co.uk Subject: Re: MySQL update X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 07 Jun 2011 13:26:05 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig02D70ABEC1FAB52D7C2E7167 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 07/06/2011 13:37, Chris Rees wrote: > On 7 June 2011 12:56, Glenn McCalley wrote: >> Trying to update MySQL from 4.1 to 5.5. >> Updating mysql-client first. >> Make works great, but make install refuses to install saying 5.5 confl= icts >> with 4.1, run >> pkg_delete for 4.1. >> pkg_delete for 4.1 refuses to deinstall as all the php52 packages >> (extensions, mysql, mysqli, pdo_mysql etc.) depend on mysql 4.1. >> >> Question: Do I have to deinstall everything, and then put it all back= >> together, or can I force the mysql 5.5 client and 5.5 server to instal= l? >> >=20 > I'm at work at the moment, so I can't test these, sorry. >=20 > Firstly, get portmaster: >=20 > # pkg_add -r portmaster >=20 > Then read the manpage: >=20 > % man portmaster >=20 > Try something like: >=20 > # portmaster -o databases/mysql55-client mysql-client >=20 > # portmaster -o databases/mysql55-server mysql-server >=20 > Then, because you haven't read the manpage you'll have to confirm > everything. Read the manpage! >=20 > If it doesn't work (because I made a mistake with the -o syntax), read > the manpage and then let us have the output. After doing that, you will also need to: portmaster -fr databases/mysql55-client to relink everything against the new libmysql.so -- portmaster defaults to simply deleting any old shlibs when there is an ABI version bump, so anything dependent on the older version will cease to function corrrectly[*] from that point. There is a '-w' option which can help smooth over such transitions, but even that is no panacea. If you accidentally end up trying to load two different versions of libmysql.so into the same application, it will result in crashyness. Cheers, Matthew [*] ie. you can't /start/ it: stuff that is already running will mostly be OK. --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate JID: matthew@infracaninophile.co.uk Kent, CT11 9PW --------------enig02D70ABEC1FAB52D7C2E7167 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.14 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk3uJtcACgkQ8Mjk52CukIzkOgCdGeQcx7InLIyzzzTfeCl4FKiK 10QAmwR5oT2KvfM4sLIlN3e72rcaawIt =UB7t -----END PGP SIGNATURE----- --------------enig02D70ABEC1FAB52D7C2E7167--