From owner-freebsd-questions@FreeBSD.ORG  Fri Sep  3 16:58:02 2004
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 1CBFB16A4CE
	for <freebsd-questions@freebsd.org>;
	Fri,  3 Sep 2004 16:58:02 +0000 (GMT)
Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.204])
	by mx1.FreeBSD.org (Postfix) with ESMTP id CA7BD43D1F
	for <freebsd-questions@freebsd.org>;
	Fri,  3 Sep 2004 16:58:01 +0000 (GMT)
	(envelope-from ryallsd@gmail.com)
Received: by mproxy.gmail.com with SMTP id 77so8620rnl
	for <freebsd-questions@freebsd.org>;
	Fri, 03 Sep 2004 09:57:58 -0700 (PDT)
Received: by 10.38.74.61 with SMTP id w61mr91117rna;
        Fri, 03 Sep 2004 09:57:58 -0700 (PDT)
Received: by 10.38.96.36 with HTTP; Fri, 3 Sep 2004 09:57:58 -0700 (PDT)
Message-ID: <d5eb95fc04090309574407f3f@mail.gmail.com>
Date: Fri, 3 Sep 2004 09:57:58 -0700
From: Derrick Ryalls <ryallsd@gmail.com>
To: Peter Risdon <peter@circlesquared.com>
In-Reply-To: <41389054.90304@circlesquared.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <1D64B3BF-FDAF-11D8-ABDA-000D9338770A@chrononomicon.com>
	 <20040903140215.GB23032@happy-idiot-talk.infracaninophile.co.uk>
	 <41389054.90304@circlesquared.com>
cc: freebsd-questions@freebsd.org
cc: Bart Silverstrim <bsilver@chrononomicon.com>
Subject: Re: Moving MySQL database
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: Derrick Ryalls <ryallsd@gmail.com>
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, 03 Sep 2004 16:58:02 -0000

> > I'd do it this way:
> >
> >     i) Stop mysql

I would actually perform a full mysqldump first and save that off. 
SQL dump file is more flexible concerning version changes than is
saving the actual db files.