From owner-freebsd-questions@FreeBSD.ORG  Thu May 29 09:16:19 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 00A0D37B401
	for <freebsd-questions@freebsd.org>;
	Thu, 29 May 2003 09:16:19 -0700 (PDT)
Received: from mail.hitmedia.com (mail.hitmedia.com [205.162.11.163])
	by mx1.FreeBSD.org (Postfix) with SMTP id 62B1343F75
	for <freebsd-questions@freebsd.org>;
	Thu, 29 May 2003 09:16:18 -0700 (PDT)
	(envelope-from bsdlap@hitmedia.com)
Received: (qmail 96071 invoked by uid 0); 29 May 2003 16:16:18 -0000
Date: Thu, 29 May 2003 09:16:18 -0700
From: BSD baby <bsdlap@hitmedia.com>
To: Ian Barnes <ian@cerebellum.za.net>
Message-ID: <20030529161618.GA95757@mail.hitmedia.com>
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
cc: freebsd-questions@freebsd.org
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: Thu, 29 May 2003 16:16:19 -0000

> 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 ??

The databases are in /var/db/mysql

The smartest thing would be to do (as root user):

mysqladmin -u YourUsername -p shutdown
cd /var/db/mysql
tar cvfz MyDatabases.tgz *
mv MyDatabases.tgz /home/

That will stop your database server, and save all your data in your /home/ dir.

Then, when you want to restore them, IF they're not there after a new install, just do:

cd /var/db/mysql
rm *
tar xvfz /home/MyDatabases.tgz