From owner-freebsd-questions@FreeBSD.ORG  Fri Aug 29 11:56:15 2003
Return-Path: <owner-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 DFF0B16A4BF
	for <freebsd-questions@freebsd.org>;
	Fri, 29 Aug 2003 11:56:15 -0700 (PDT)
Received: from mclean.mail.mindspring.net (mclean.mail.mindspring.net
	[207.69.200.57])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 36D0B43F85
	for <freebsd-questions@freebsd.org>;
	Fri, 29 Aug 2003 11:56:15 -0700 (PDT)
	(envelope-from tristan11@mindspring.com)
Received: from h-69-3-244-46.snvacaid.covad.net ([69.3.244.46]
	helo=mindspring.com)
	by mclean.mail.mindspring.net with esmtp (Exim 3.33 #1)
	id 19soPu-0004yT-00
	for freebsd-questions@freebsd.org; Fri, 29 Aug 2003 14:56:14 -0400
Date: Fri, 29 Aug 2003 11:56:12 -0700
Mime-Version: 1.0 (Apple Message framework v552)
From: Michelle <tristan11@mindspring.com>
To: freebsd-questions@freebsd.org
In-Reply-To: <001e01c36e54$164e14f0$6501a8c0@croydon>
Message-Id: <75C451F8-DA52-11D7-8C70-000393843210@mindspring.com>
X-Mailer: Apple Mail (2.552)
Content-Type: text/plain;
	charset=US-ASCII;
	format=flowed
Content-Transfer-Encoding: 7bit
X-Content-Filtered-By: Mailman/MimeDel 2.1.1
Subject: upgrading mysql
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
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, 29 Aug 2003 18:56:16 -0000

I would like to upgrade mysql from mysql-server-3.23.54 to 
mysql-server-3.23.57 and understand that I will need to do a dump 
before upgrading since the upgrade needs to overwrite the databases.  
Since I have never done this before, I just want to make sure I have 
the correct steps after reading over the mysql site and the man pages.

First I will dump all of my databases:

mysqldump  -A > backup-file.sql

Then I will shutdown the mysql server and upgrade the mysql port with 
the environment variable OVERWRITE_DB defined when running make install.

To rebuild the databases do I simply use:

mysqldump --all-databases > backup-file.sql

and then restart the mysql server using mysqld_safe

Am I missing any steps?

Thank you,
Michelle