[Gllug] Tape backups

Simon Wilcox essuu at ourshack.com
Tue Feb 17 14:09:00 UTC 2009


On 17/2/09 13:45, John Edwards wrote:
> So how much difference is there between backing up the raw database
> files from /var/lib/mysql and making a mysqldump ? 

Lots :-)

> I can see that the raw files would be faster to restore, but won't
> a dump be safer, more portable and easier to find/fix errors with?

MySQL uses a memory cache so you need to make sure it's flushed out 
before copying the files over. Google for 'FLUSH TABLES WITH READ LOCK' 
which will return lots of options.

A mysqldump is, as you say, more portable and can be edited by hand.

S.
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug




More information about the GLLUG mailing list