From owner-freebsd-questions@FreeBSD.ORG  Fri Jan  2 16:04:39 2009
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 F1F351065670
	for <freebsd-questions@freebsd.org>;
	Fri,  2 Jan 2009 16:04:39 +0000 (UTC)
	(envelope-from apseudoutopia@gmail.com)
Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.169])
	by mx1.freebsd.org (Postfix) with ESMTP id B1F808FC14
	for <freebsd-questions@freebsd.org>;
	Fri,  2 Jan 2009 16:04:39 +0000 (UTC)
	(envelope-from apseudoutopia@gmail.com)
Received: by wf-out-1314.google.com with SMTP id 24so8744983wfg.7
	for <freebsd-questions@freebsd.org>;
	Fri, 02 Jan 2009 08:04:39 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type
	:content-transfer-encoding:content-disposition:references;
	bh=4gzF98ZDFlnD2CkaHrg1ritt7eCH12ThreghW0AKPkE=;
	b=pAhuq59+/lO10J5R1gWFuqc122zTTdPpJsLKcN8KSeQ3TIPzvpV9n8Cs8D6ohbIrqH
	eGmBdHsPKSyJ+6nIqRZEop6zRySGH8QcBGOomERkcdkQA+0BuMkOyXkJHEJT3nt3jlGF
	Hh0+Q2cv3tjxgbfMPMAlVutQ+s1ESRnf4wBAQ=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=MjM+Iah+3c9QfqM4s1YfnQ8oIuTJ5uIvHr4B6JFs8MHkCbVNFfiy61Nevn6t0B0xC7
	6jUaV6tKx0ZnJKBNSiyjaZ0Me0V0Ai+vtGvJLUZ+6y9M6KDZRR9eBXLCnukzzRqmHDa4
	GcowKHePXfeO5zYj91S9eEGq8J8HOmDHhxm0U=
Received: by 10.142.134.17 with SMTP id h17mr7379071wfd.136.1230912279436;
	Fri, 02 Jan 2009 08:04:39 -0800 (PST)
Received: by 10.143.59.9 with HTTP; Fri, 2 Jan 2009 08:04:39 -0800 (PST)
Message-ID: <27ade5280901020804l6bb8e89ehdcccc670634babb3@mail.gmail.com>
Date: Fri, 2 Jan 2009 11:04:39 -0500
From: APseudoUtopia <apseudoutopia@gmail.com>
To: "Jos Chrispijn" <kernel@webrz.net>
In-Reply-To: <495E3551.40507@webrz.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <495E3551.40507@webrz.net>
Cc: freebsd-questions@freebsd.org
Subject: Re: MySQL version upgrade
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: Fri, 02 Jan 2009 16:04:40 -0000

On Fri, Jan 2, 2009 at 10:40 AM, Jos Chrispijn <kernel@webrz.net> wrote:
> I currently have running:
>
> mysql-client-4.0.27 & mysql-server-4.0.27, who I would like to upgrade to
> mysql-client-5.0.75 & mysql-server-5.0.75
>
> I can imagine that there is a database issue here as the 4.0 records might
> differ from the 5.0 ones.
> Is there a way of upgrading smoothly? I did upgrade my databases in advance.
>
> -- best Wishes for 2009 and thank you for your support in the last year.
> _______________________________________________
> freebsd-questions@freebsd.org mailing list

I'd recommend that you read up on the MySQL documentation on the
subject of upgrading.
I don't mean to be mean, but it's not exactly a FreeBSD issue :-P

http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
and
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html