From owner-freebsd-questions@FreeBSD.ORG  Sat Sep  2 15:58:37 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
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 B805816A4E0
	for <freebsd-questions@freebsd.org>;
	Sat,  2 Sep 2006 15:58:37 +0000 (UTC)
	(envelope-from dmehler26@woh.rr.com)
Received: from ms-smtp-04.ohiordc.rr.com (ms-smtp-04.ohiordc.rr.com
	[65.24.5.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3D3C443D45
	for <freebsd-questions@freebsd.org>;
	Sat,  2 Sep 2006 15:58:36 +0000 (GMT)
	(envelope-from dmehler26@woh.rr.com)
Received: from satellite (cpe-71-65-68-20.woh.res.rr.com [71.65.68.20])
	by ms-smtp-04.ohiordc.rr.com (8.13.6/8.13.6) with SMTP id
	k82FwZVC019724 for <freebsd-questions@freebsd.org>;
	Sat, 2 Sep 2006 11:58:35 -0400 (EDT)
Message-ID: <000301c6cea8$a5cf4650$0200a8c0@satellite>
From: "Dave" <dmehler26@woh.rr.com>
To: <freebsd-questions@freebsd.org>
Date: Sat, 2 Sep 2006 11:58:34 -0400
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2869
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-Virus-Scanned: Symantec AntiVirus Scan Engine
Subject: upgrading mysql client and server
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: Dave <dmehler26@woh.rr.com>
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: Sat, 02 Sep 2006 15:58:37 -0000

Hello,
    I've got mysql server and client v4.1 running on a FreeBSD6.x box. They 
were installed via ports not packages using custom make options which i have 
in portupgrade's pkgtools.conf file. I now would like to upgrade both of 
them to v5, without causing dependency issues with installed apps or with my 
databases. What i was wondering is is there an easy way of doing this? I am 
concerned about my databases, i've done mysqldumps on them, but i have to 
manually go in and create information. I'd rather feed the mysql command a 
complete file and have it automatically regenerate everything. I'm also 
concerned about any compatibility issues. Any help appreciated.
Thanks.
Dave.