Re: Dump and Restore Utility
On Thu, Jan 29, 2009 at 06:23:42PM +0100, Johannes Wiedersich wrote:
> Martin McCormick wrote:
> > Nicolas KOWALSKI writes:
> >> Yes, dump is working well with ext3 filesystems, as long as they
> >> are not actively modified. LVM may come to help here.
> > Many thanks. That is a problem more or less with any backup method
> > that doesn't unmount and convert to read-only a given file system.
> I use rsync. It's fairly consistent, even if the file system is in use.
> Your situation will be worse, however, if, say a data base application
> writes a lot to many different files at different times and the
> combination of different files might turn out inconsistent.
Shouldn't databases be backed-up with a database dump to a file anyway
rather than backing up the raw database files? You could run the
database dump and pipe the output through ssh to the backup server into
a file there.