[Gllug] scp whole drive with out copying /proc/kcore?

Thu Nov 1 13:41:05 UTC 2001

Steve Nicholson(steve.nicholson at yoursolutions.com)@Thu, Nov 01, 2001 at 02:53:43AM -0000:
> 
> Is rsync ok to use for copying MySQL database files for backing up to
> another server?  I guess you need to flush the tables first?
> 

yes, if done in the right way.  to backup the raw database files, i'd say you need to stop the database, a complete shutdown.

the other option, is to dump out all the tables and descriptions to a text file, and then back that up.  has the advantage that you can leave the DB running,a dn do it all online.

once you have a copy of the 'data' whih ever method you opt for, then rsync will also be fine.  rsync is cool, IIRC you can run it over an ssh session if security is a concern.

-- 

PGP key:  http://codex.net/pgp/pgp.asc

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug