>-----Original Message----- >From: Nick Rout [mailto:[email protected]] > >On Tue, May 10, 2011 at 2:02 PM, Bryce Stenberg ><[email protected]> wrote: >> >> Possibly yet another alternative backup scheme that doesn't require a >> change of run level (which I use on our one ubuntu server) >is to use LVM partitions, but keep lvm space free to snapshot backups. > >One thing to remember is that database backups are ideally done with >the text based tools, at least for MySQL anyway. The binary data is >not guaranteed to be compatible with versions other than the version >that created it. >
Yes, snapshot backups are only good for recovering data to the same version of database, or recovering the entire system - like when your hard drive dies... If entire system, and database was properly blocked ( mysql> FLUSH TABLES WITH READ LOCK; or informix> onmode -c block; ) then you have a consistent point in time to recover to. After restoring all it should behave the same as if you had just pulled the power on your server, probably better since it was put in consistent state before snapshot backup. For our databases (windows and linux) we use both snapshots and the database native tools to do backups - you can never have enough backup protection :) Regards, Bryce. DISCLAIMER: If you have received this email in error, please notify us immediately by reply email, facsimile or collect telephone call to +64 3 9641200 and destroy the original. Please refer to full DISCLAIMER at http://www.hrnz.co.nz/eDisclaimer.htm _______________________________________________ Linux-users mailing list [email protected] http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
