Date: Fri, 3 Sep 2004 20:08:45 +0100 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: Peter Risdon <peter@circlesquared.com> Cc: Bart Silverstrim <bsilver@chrononomicon.com> Subject: Re: Moving MySQL database Message-ID: <20040903190845.GA22237@happy-idiot-talk.infracaninophile.co.uk> In-Reply-To: <41389054.90304@circlesquared.com> References: <1D64B3BF-FDAF-11D8-ABDA-000D9338770A@chrononomicon.com> <20040903140215.GB23032@happy-idiot-talk.infracaninophile.co.uk> <41389054.90304@circlesquared.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040903190845.GA22237>
