From owner-freebsd-questions@FreeBSD.ORG Wed May 30 17:18:40 2012 Return-Path: Delivered-To: FreeBSD-questions@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 967F21065672 for ; Wed, 30 May 2012 17:18:40 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) by mx1.freebsd.org (Postfix) with ESMTP id 1CB0C8FC08 for ; Wed, 30 May 2012 17:18:39 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [81.187.76.163]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.5/8.14.5) with ESMTP id q4UHIWxF083966 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO); Wed, 30 May 2012 18:18:33 +0100 (BST) (envelope-from matthew@FreeBSD.org) X-DKIM: OpenDKIM Filter v2.5.2 smtp.infracaninophile.co.uk q4UHIWxF083966 Authentication-Results: smtp.infracaninophile.co.uk/q4UHIWxF083966; dkim=none (no signature); dkim-adsp=none Message-ID: <4FC65661.2020709@FreeBSD.org> Date: Wed, 30 May 2012 18:18:25 +0100 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 MIME-Version: 1.0 To: Gene References: <20120530165017.M37727@brightstar.bomgardner.net> In-Reply-To: <20120530165017.M37727@brightstar.bomgardner.net> X-Enigmail-Version: 1.4.1 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigA4EE6858636A8B88B94B8C04" X-Virus-Scanned: clamav-milter 0.97.4 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.6 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham version=3.3.2 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on lucid-nonsense.infracaninophile.co.uk Cc: Freebsd Questions Subject: Re: Corrections to: unable to upgrade to mysql55-server 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: Wed, 30 May 2012 17:18:40 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigA4EE6858636A8B88B94B8C04 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On 30/05/2012 17:57, Gene wrote: > I've been trying to install the port databases/mysql55-server, updatin= g from=20 > the older 5.4 version. mysql55-client installed just fine. However, wh= en I=20 > "make" the '-server' port I get the errors shown in the first listing b= elow.=20 > So I tried=20 > "portmanager databases/mysql55-server -l -u" =20 > (latest version of portmanager - 0.4.1_9).=20 Did you update to databases/mysql55-client before trying this? mysqlXX-server depends on mysqlXX-client for the libmysql shared library and related header files. Generally to switch from mysql 5.4 to mysql 5.5 you'ld do something like this: 0) Backups, fasting, ritual cleansing, sacrifice of black cockerel, you know the drill. 1) Stop MySQL -- plus any web servers or whatever that access mysql. # /usr/local/etc/rc.d/mysql-server stop # ... 2) If there is any mention of MYSQL related variables in /etc/make.conf, particularly those referring to version numbers, comment them out. 3) Upgrade mysql-client: # portmaster -o databases/mysql55-client 'mysql-client-5.4.*' 4) Upgrade mysql-server: # portmaster -o databases/mysql55-server 'mysql-server-5.4.*' 5) If you've got them installed, upgrade mysql-scripts: # portmaster -o databases/mysql55-scripts 'mysql-scripts-5.4.*' 6) Upgrade anything that links against libmysql.so -- you can use sysutils/bsdadminscripts which contains a handy script to tell you what applications on your system are affected. Or, for the lazy and those with excess spare time: # portmaster -r databases/mysql55-client (but this will do far more work than necessary) 7) Restart mysql and run the supplied program to update schemas etc. # /usr/local/etc/rc.d/mysql-server start # mysql_upgrade 8) Restart any applications that use mysql. 9) Test. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey --------------enigA4EE6858636A8B88B94B8C04 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.16 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk/GVmgACgkQ8Mjk52CukIxm2gCfU9i1ehRz8fvEffl5QCZQmF/S 9wUAmgPvDffVIda+eHHmZ0Myu42FPDnI =kBeW -----END PGP SIGNATURE----- --------------enigA4EE6858636A8B88B94B8C04--