[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