From owner-freebsd-questions@FreeBSD.ORG Fri Sep 3 19:09:17 2004 Return-Path: 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 5E96016A4CE for ; Fri, 3 Sep 2004 19:09:17 +0000 (GMT) Received: from smtp.infracaninophile.co.uk (happy-idiot-talk.infracaninophile.co.uk [81.2.69.218]) by mx1.FreeBSD.org (Postfix) with ESMTP id BA7BA43D48 for ; Fri, 3 Sep 2004 19:09:15 +0000 (GMT) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost.infracaninophile.co.uk [IPv6:::1])i83J8nhV022460 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 3 Sep 2004 20:08:49 +0100 (BST) (envelope-from matthew@happy-idiot-talk.infracaninophile.co.uk) Received: (from matthew@localhost)i83J8j5m022459; Fri, 3 Sep 2004 20:08:45 +0100 (BST) (envelope-from matthew) Date: Fri, 3 Sep 2004 20:08:45 +0100 From: Matthew Seaman To: Peter Risdon Message-ID: <20040903190845.GA22237@happy-idiot-talk.infracaninophile.co.uk> Mail-Followup-To: Matthew Seaman , Peter Risdon , Bart Silverstrim , freebsd-questions@freebsd.org References: <1D64B3BF-FDAF-11D8-ABDA-000D9338770A@chrononomicon.com> <20040903140215.GB23032@happy-idiot-talk.infracaninophile.co.uk> <41389054.90304@circlesquared.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="r5Pyd7+fXNt84Ff3" Content-Disposition: inline In-Reply-To: <41389054.90304@circlesquared.com> User-Agent: Mutt/1.4.2.1i X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-1.5.6 (smtp.infracaninophile.co.uk [IPv6:::1]); Fri, 03 Sep 2004 20:08:50 +0100 (BST) X-Virus-Scanned: clamd / ClamAV version devel-20040705, clamav-milter version 0.74a on smtp.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.64 X-Spam-Checker-Version: SpamAssassin 2.64 (2004-01-11) on happy-idiot-talk.infracaninophile.co.uk cc: freebsd-questions@freebsd.org cc: Bart Silverstrim Subject: Re: Moving MySQL database X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 03 Sep 2004 19:09:17 -0000 --r5Pyd7+fXNt84Ff3 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Sep 03, 2004 at 04:40:04PM +0100, Peter Risdon wrote: > Matthew Seaman wrote: > > iii) Move the database files to their new location, taking care to > > preserve ownership, permissions, timestamps etc. >=20 >=20 > Might a cp -p be slightly more cautious/paranoid until step vi has been= =20 > completed? > > vi) Restart the mysql server. Verify that your data survived the > > move. Absolutely. I was kind of assuming that anyone would automatically take a backup before doing anything of this nature. Perhaps I should have spelt that out. Cheers, Matthew=09 --=20 Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks Savill Way PGP: http://www.infracaninophile.co.uk/pgpkey Marlow Tel: +44 1628 476614 Bucks., SL7 1TH UK --r5Pyd7+fXNt84Ff3 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (FreeBSD) iD8DBQFBOME9iD657aJF7eIRAlbiAJ4+pi9eAs7ICR71gXy7OW9ZsbAiOwCgpGa9 kMmP1aPZvwmYGoLgFP716ww= =y2Gp -----END PGP SIGNATURE----- --r5Pyd7+fXNt84Ff3--