From owner-freebsd-questions@FreeBSD.ORG Tue Mar 23 13:59:51 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 2926016A4CE for ; Tue, 23 Mar 2004 13:59:51 -0800 (PST) Received: from smtp.infracaninophile.co.uk (happy-idiot-talk.infracaninophile.co.uk [81.2.69.218]) by mx1.FreeBSD.org (Postfix) with ESMTP id 639A343D1D for ; Tue, 23 Mar 2004 13:59:50 -0800 (PST) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost.infracaninophile.co.uk [IPv6:::1])i2NLxhhK005239 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 23 Mar 2004 21:59:43 GMT (envelope-from matthew@happy-idiot-talk.infracaninophile.co.uk) Received: (from matthew@localhost)id i2NLxhKo005238; Tue, 23 Mar 2004 21:59:43 GMT (envelope-from matthew) Date: Tue, 23 Mar 2004 21:59:43 +0000 From: Matthew Seaman To: "Paul D. Schmidt" Message-ID: <20040323215943.GB4312@happy-idiot-talk.infracaninophile.co.uk> Mail-Followup-To: Matthew Seaman , "Paul D. Schmidt" , freebsd-questions@freebsd.org References: <4060A7CE.7010100@uberhacker.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="PmA2V3Z32TCmWXqI" Content-Disposition: inline In-Reply-To: <4060A7CE.7010100@uberhacker.org> User-Agent: Mutt/1.5.6i X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on happy-idiot-talk.infracaninophile.co.uk X-Virus-Scanned: clamd / ClamAV version devel-20040316, clamav-milter version 0.67l cc: freebsd-questions@freebsd.org Subject: Re: Question about something in ports/CHANGES file (re: upgrading MySQL) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 Mar 2004 21:59:51 -0000 --PmA2V3Z32TCmWXqI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Mar 23, 2004 at 01:10:38PM -0800, Paul D. Schmidt wrote: > Where can I find more information about the following? (Taken > from /usr/ports/CHANGES) >=20 > 20040204: > ... > The ports system now supports MySQL 3.23, 4.0, 4.1, and 5.0. > Also, the ability to scale to newer versions was also but in > place. > ... >=20 > I don't see anything in the mysql40-server Makefile that has anything > to do with upgrades...where else should I look? I'm trying to convert > from a 3.23 system. That's not too difficult to do: 0) Get a list of all the applications that linl against the mysql323-client port: % pkg_info -R mysql-client\* i) Backup your database. See mysqldump(1). You shouldn't need this backup copy unless things go horribly wrong. ii) Delete the databases/mysql323-{client,server} ports using 'pkg_delete -f'. This shouldn't affect anything under /var/db (or wherever you've set DB_DIR to). iii) Install mysql40-server and mysql40-client ports making sure you add 'OVERWRITE_DB=3Dno' to the make arguments. You should be able to start up mysql-4.0.x, log into your databases from the command line and check that things are still OK. mysql40 will happily read database files created by mysql323: I think it even autodetects that situation and updates the files for you. You should check all of the GRANT tables as mysql40 introduced some new grantable permissions, and you may need to fiddle about with user settings. iv) Optionally edit /etc/make.conf and add WANT_MYSQL_VER=3D40 -- you don't have to do this, as the ports system will work out which version of mysql you have installed automatically, but it does just make sure. v) Reinstall all of the ports you listed in (0) that linked against the mysql323-client port (except, obviously, mysql-server-3.23.x), so that they now link against mysql40-client. If you're using portupgrade(1) you may have to run through 'pkgdb -Fvu' to placate its worries about missing dependencies before it will let you run 'portupgrade -f'. And that's all there is to it, really. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks Savill Way PGP: http://www.infracaninophile.co.uk/pgpkey Marlow Tel: +44 1628 476614 Bucks., SL7 1TH UK --PmA2V3Z32TCmWXqI Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQFAYLNPdtESqEQa7a0RAtXJAJ96zwmMjFvoFqOD77iSq5knkMldBwCdG4sA 0kKsVnxKwCBdTtrKc8ccm58= =H1PM -----END PGP SIGNATURE----- --PmA2V3Z32TCmWXqI--