From owner-freebsd-questions@FreeBSD.ORG  Mon Jul 30 07:15:06 2007
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 120EC16A417
	for <freebsd-questions@freebsd.org>;
	Mon, 30 Jul 2007 07:15:06 +0000 (UTC)
	(envelope-from wodfer@gmail.com)
Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179])
	by mx1.freebsd.org (Postfix) with ESMTP id E69AC13C428
	for <freebsd-questions@freebsd.org>;
	Mon, 30 Jul 2007 07:15:05 +0000 (UTC)
	(envelope-from wodfer@gmail.com)
Received: by wa-out-1112.google.com with SMTP id k17so1574297waf
	for <freebsd-questions@freebsd.org>;
	Mon, 30 Jul 2007 00:15:05 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	b=L+nxLX/p6mfgLck+1HxaAeLE7YaAj3KZqBnyP0jdDWBZw4S8SId2Szknm5o26AecjoaDev4x422d0vMAwewuMluV7k7ra1xgoXi2ZcI8oHEmROpswqvNE1Y4ZN5FRK4ziiSjOUt7zc9a+W+JuiIgiHeyJWVNTFh+RMOnbG0/7UE=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=q3bXIiSvYm41YWnEphFYbeK2ZFGgt8CSDY/J7kY1rEzev3223IHDPa9FWCMvuAOwLOk2Fbu6qf/INNMEp1b/LrVFBMTAiKL4iKHPYRbsL3bCNac2h6yCaSJxfMsuThL/IlX3T4e1MqE6twgQ96HtvxAcpvZmarIdnhY9oc2qM5A=
Received: by 10.114.160.1 with SMTP id i1mr5297671wae.1185779705605;
	Mon, 30 Jul 2007 00:15:05 -0700 (PDT)
Received: by 10.114.147.2 with HTTP; Mon, 30 Jul 2007 00:15:05 -0700 (PDT)
Message-ID: <23ed14b80707300015q614a62bfv5771d1ffc3e35a08@mail.gmail.com>
Date: Mon, 30 Jul 2007 09:15:05 +0200
From: "=?ISO-8859-1?Q?Andreas_Wider=F8e_Andersen?=" <wodfer@gmail.com>
To: freebsd-questions <freebsd-questions@freebsd.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Subject: Best way to upgrade mysql-server?
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: Mon, 30 Jul 2007 07:15:06 -0000

Hi,
I recently upgraded from 3.23 to 4.027. My steps were:

1. Stopped the mysql server
2. make deinstall in mysql-server 3.23
3. make deinstall in mysql-client 3.23
4. make install clean in mysql-server 4.0.27
5. Ran the mysql_fix_privilege_tables
6. Started the mysql server again

(and ofcourse backups before step 1)

Things seem to be working fine.

In regards to the existing database files, are there more "correct" ways of
doing an upgrade on a production server?

Also, does anyone have some good advice on optimizing tables, correcting and
speeding up things after an upgrade?

Thanks and best regards,
Andreas