From owner-freebsd-questions@FreeBSD.ORG  Thu May 29 20:23:16 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 C17E137B401
	for <freebsd-questions@freebsd.org>;
	Thu, 29 May 2003 20:23:16 -0700 (PDT)
Received: from mail.munk.nu (213-152-51-194.dsl.eclipse.net.uk
	[213.152.51.194])
	by mx1.FreeBSD.org (Postfix) with ESMTP id C285D43FA3
	for <freebsd-questions@freebsd.org>;
	Thu, 29 May 2003 20:23:15 -0700 (PDT)
	(envelope-from munk@mail.munk.nu)
Received: from munk by mail.munk.nu with local (Exim 4.20)
	id 19LaU4-000Cet-26
	for freebsd-questions@freebsd.org; Fri, 30 May 2003 04:23:12 +0100
Date: Fri, 30 May 2003 04:23:12 +0100
From: Jez Hancock <jez.hancock@munk.nu>
To: freebsd-questions@freebsd.org
Message-ID: <20030530032312.GB48510@users.munk.nu>
Mail-Followup-To: freebsd-questions@freebsd.org
References: <PPECLBJKHADMJKGPJMEFCEBDCKAA.ian@cerebellum.za.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <PPECLBJKHADMJKGPJMEFCEBDCKAA.ian@cerebellum.za.net>
User-Agent: Mutt/1.4.1i
Sender: User Munk <munk@mail.munk.nu>
Subject: Re: 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, 30 May 2003 03:23:17 -0000

On Thu, May 29, 2003 at 06:08:53PM +0200, Ian Barnes wrote:
> Hi,
> 
> I want to remove my mysql installation and re-install from scratch. Now the
> problem. I have 6 active databases. How can i make sure that i dont loose
> those. And that when i have re-installed, that they work immediatilly ??
fwiw you can simply do:
cd /var/db
mv mysql mysql.bak
(uninstall/reinstall w/e mysql)
rm -fr /var/db/mysql
mv /var/db/mysql.bak /var/db/mysql

afaik using something as complicated as tar to archive the dbs first
isn't necessary - mv retains the permission settings fine.