[Gllug] Tape backups

[John Edwards]

On Tue, Feb 17, 2009 at 01:31:26PM +0000, Bruce Richardson wrote:
<snip> 
> Then don't backup the live db, use replication and backup a replica.
> Then you can afford to stop the replica entirely while you take a
> snapshot/dump, if you want.

So how much difference is there between backing up the raw database
files from /var/lib/mysql and making a mysqldump ? 

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?


-- 
#---------------------------------------------------------#
|    John Edwards   Email: john at cornerstonelinux.co.uk    |
#---------------------------------------------------------#
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 196 bytes
Desc: Digital signature
URL: <http://mailman.lug.org.uk/pipermail/gllug/attachments/20090217/f71ef5ea/attachment.pgp>
-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug