From owner-freebsd-questions@FreeBSD.ORG  Wed Dec 29 14:10:23 2010
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 EB46E106564A
	for <freebsd-questions@freebsd.org>;
	Wed, 29 Dec 2010 14:10:23 +0000 (UTC)
	(envelope-from wmoran@potentialtech.com)
Received: from mail.potentialtech.com (internet.potentialtech.com
	[66.167.251.6]) by mx1.freebsd.org (Postfix) with ESMTP id B26038FC08
	for <freebsd-questions@freebsd.org>;
	Wed, 29 Dec 2010 14:10:23 +0000 (UTC)
Received: from overdrive.ws.pitbpa0.priv.collaborativefusion.com
	(pr40.pitbpa0.pub.collaborativefusion.com [206.210.89.202])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.potentialtech.com (Postfix) with ESMTPSA id 714F0F7419;
	Wed, 29 Dec 2010 09:10:22 -0500 (EST)
Date: Wed, 29 Dec 2010 09:10:21 -0500
From: Bill Moran <wmoran@potentialtech.com>
To: Odhiambo Washington <odhiambo@gmail.com>
Message-Id: <20101229091021.ff3c09cc.wmoran@potentialtech.com>
In-Reply-To: <AANLkTinvCF+i7JCKpUYNhzykjfUad4ELZxmM1nx=rx5p@mail.gmail.com>
References: <AANLkTikPbdiAiO-5=R5mBbMhSTBO-sVeqvcWGJY-fpwN@mail.gmail.com>
	<AANLkTinvCF+i7JCKpUYNhzykjfUad4ELZxmM1nx=rx5p@mail.gmail.com>
Organization: Bill Moran
X-Mailer: Sylpheed 3.0.3 (GTK+ 2.20.1; amd64-portbld-freebsd8.0)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Cc: FreeBSD Mailing List <freebsd-questions@freebsd.org>,
	Nerius Landys <nlandys@gmail.com>
Subject: Re: MySQL 5.5.7->5.5.8 instructions seem scary
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 29 Dec 2010 14:10:24 -0000

In response to Odhiambo Washington <odhiambo@gmail.com>:

> On Wed, Dec 29, 2010 at 1:57 PM, Nerius Landys <nlandys@gmail.com> wrote:
> 
> > I read this in /usr/ports/UPDATING today:
> >
> > =================================================
> > 20101227:
> >  AFFECTS: users of databases/mysql55-server
> >  AUTHOR: ale@FreeBSD.org
> >
> >  MySQL 5.5 has been updated to 5.5.8 GA release. Since layout is
> >  changed you should remove mysql55-{client/server/scripts} ports
> >  before upgrading. The build system is changed too, so expect
> >  failures.
> > =================================================
> >
> >
> > Now that seems pretty scary.  Remove all mysql packages from my system?!?!
> > Expect failures?!?!?
> >
> > I have important data in my current mysql install.
> >
> If there is no reason for you to run it, then keep off.
> Otherwise backup your DB and follow the instructions:-)

Better yet, make a jail, install the version of MySQL you're currently
using and copy your data over, then practice upgrading in the jail.
Once you have the procedure figured out, you can execute it on the
production system with a high level of confidence.

-- 
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/