From owner-freebsd-questions@FreeBSD.ORG  Fri Jul 27 14:17:50 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 7AE1016A418
	for <questions@freebsd.org>; Fri, 27 Jul 2007 14:17:50 +0000 (UTC)
	(envelope-from roberthuff@rcn.com)
Received: from smtp02.lnh.mail.rcn.net (smtp02.lnh.mail.rcn.net
	[207.172.157.102])
	by mx1.freebsd.org (Postfix) with ESMTP id 2E1D013C442
	for <questions@freebsd.org>; Fri, 27 Jul 2007 14:17:50 +0000 (UTC)
	(envelope-from roberthuff@rcn.com)
Received: from mr02.lnh.mail.rcn.net ([207.172.157.22])
	by smtp02.lnh.mail.rcn.net with ESMTP; 27 Jul 2007 10:17:49 -0400
Received: from smtp01.lnh.mail.rcn.net (smtp01.lnh.mail.rcn.net [207.172.4.11])
	by mr02.lnh.mail.rcn.net (MOS 3.8.3-GA) with ESMTP id NPG82910;
	Fri, 27 Jul 2007 10:17:48 -0400 (EDT)
Received: from 65-78-26-179.c3-0.smr-ubr1.sbo-smr.ma.cable.rcn.com (HELO
	jerusalem.litteratus.org.litteratus.org) ([65.78.26.179])
	by smtp01.lnh.mail.rcn.net with ESMTP; 27 Jul 2007 10:17:47 -0400
From: Robert Huff <roberthuff@rcn.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <18089.65163.914777.981214@jerusalem.litteratus.org>
Date: Fri, 27 Jul 2007 10:17:47 -0400
To: questions@freebsd.org
In-Reply-To: <20070727133354.GA4021@skytracker.ca>
References: <20070727133354.GA4021@skytracker.ca>
X-Mailer: VM 7.17 under 21.5  (beta28) "fuki" XEmacs Lucid
X-Junkmail-Whitelist: YES (by domain whitelist at mr02.lnh.mail.rcn.net)
Cc: 
Subject: updating mysql database
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, 27 Jul 2007 14:17:50 -0000

David Banning writes:

>  I installed mysql 5.1 on a new system and I want to run a 4.1
>  database. I notice that not all tables work. Is there a
>  conversion to take the database from 4.1 to 5.1?

	It is my understanding that you will have to dump (using the
appropriate MySQL utilities) the database, the import it to the new
version.  But you should check the documentation for the official
policy.


				Robert Huff