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. > Then use lvcreate to create a snapshot backup, mount it and run your > backup software against the snapshot. Remove snapshot when done. > For databases just make sure they are quiesced/blocked and buffers > flushed before snapshot, after snapshot just release the blocking. > Snapshot only takes a second or two to complete. I'm pretty sure it gets > in use binaries, system seems to restore fine... > Back in 21/12/2009 I asked about this in thread "Point-in-Time Backup > and Restore - any gotchas?" where I had the start of a script to do it. > > Regards, > Bryce Stenberg.
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. _______________________________________________ Linux-users mailing list [email protected] http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
