Moving MySQL database

Matthew Seaman m.seaman at infracaninophile.co.uk
Fri Sep 3 12:09:17 PDT 2004


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.
> 
> 
> Might a cp -p be slightly more cautious/paranoid until step vi has been 
> 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	

-- 
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20040903/42ca734c/attachment.bin


More information about the freebsd-questions mailing list