Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 30 May 2012 18:18:25 +0100
From:      Matthew Seaman <matthew@FreeBSD.org>
To:        Gene <fbsd@bomgardner.net>
Cc:        Freebsd Questions <FreeBSD-questions@FreeBSD.org>
Subject:   Re: Corrections to: unable to upgrade to mysql55-server
Message-ID:  <4FC65661.2020709@FreeBSD.org>
In-Reply-To: <20120530165017.M37727@brightstar.bomgardner.net>
References:  <20120530165017.M37727@brightstar.bomgardner.net>

next in thread | previous in thread | raw e-mail | index | archive | help
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--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4FC65661.2020709>