From owner-freebsd-ports@FreeBSD.ORG  Wed Jun 27 13:36:15 2007
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
X-Original-To: freebsd-ports@freebsd.org
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id B434C16A468
	for <freebsd-ports@freebsd.org>; Wed, 27 Jun 2007 13:36:15 +0000 (UTC)
	(envelope-from jdc@parodius.com)
Received: from mx01.sc1.parodius.com (mx01.sc1.parodius.com [72.20.106.3])
	by mx1.freebsd.org (Postfix) with ESMTP id A497413C46C
	for <freebsd-ports@freebsd.org>; Wed, 27 Jun 2007 13:36:15 +0000 (UTC)
	(envelope-from jdc@parodius.com)
Received: by mx01.sc1.parodius.com (Postfix, from userid 1000)
	id 924FB1CC044; Wed, 27 Jun 2007 06:36:15 -0700 (PDT)
Date: Wed, 27 Jun 2007 06:36:15 -0700
From: Jeremy Chadwick <koitsu@FreeBSD.org>
To: Jack Stone <antennex@hotmail.com>
Message-ID: <20070627133615.GA41868@eos.sc1.parodius.com>
Mail-Followup-To: Jack Stone <antennex@hotmail.com>, freebsd-ports@freebsd.org
References: <BAY125-F273D7FBCAF6FD5A02968DBCC0A0@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <BAY125-F273D7FBCAF6FD5A02968DBCC0A0@phx.gbl>
User-Agent: Mutt/1.5.15 (2007-04-06)
Cc: freebsd-ports@freebsd.org
Subject: Re: Upgrading MySQL port
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 27 Jun 2007 13:36:15 -0000

On Wed, Jun 27, 2007 at 07:14:09AM -0500, Jack Stone wrote:
>  I need to upgrade the older generation of MySQL from 3x to 4x and without 
>  loss of the existing DBs.
> 
>  What's the best approach of doing this when jumping a generation in MySQL 
>  and keeping DBs safe in the process?

This is really not a question for -ports.  This is something you should
be asking the MySQL folks.  In fact, better yet, there's an entire
section on how to backup/restore entire databases.  Be aware that
migrating your mysql/ database is a testy thing, and if at all possible,
read the docs thoroughly or do it by hand.

http://dev.mysql.com/doc/refman/4.1/en/upgrade.html

http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html

http://dev.mysql.com/doc/refman/4.1/en/disaster-prevention.html

-- 
| Jeremy Chadwick                                    jdc at parodius.com |
| Parodius Networking                           http://www.parodius.com/ |
| UNIX Systems Administrator                      Mountain View, CA, USA |
| Making life hard for others since 1977.                  PGP: 4BD6C0CB |