Author: Chris Dahn <chris.dahn AT computer DOT org>
Date: Tue, 15 Apr 2003 14:16:34 -0400
I believe the proper thing to do is to use mysqldump or the equivalent, and then backup the dumped database file. If you backup a live database, you may end up with inconsistencies after a restore. -
I was wondering if it is safe to do a filesystem dump using the dump command on running databases such as postfix and mysql? Thanks. -CM Depends on what you mean by "safe". Nothing bad should happen
Author: "Chad Morland" <chad.morland AT inquent DOT com>
Date: Tue, 15 Apr 2003 13:44:27 -0400
running resulting the dump, I'm not too worried about restoring the database from the dump as I plan on using mysqldump and the postgres pg_dumpall commands for the database backups. I just needed to
Author: "Chad Morland" <chad.morland AT inquent DOT com>
Date: Tue, 15 Apr 2003 15:23:24 -0400
Postfix was a typo... it was meant to read postgres. I understand that the database information in the dump image will not be correct and will provide inconsistancies. However, my aim is to create an
Author: Benjamin Lewis <bhlewis AT pythia.itsp.purdue DOT edu>
Date: Tue, 15 Apr 2003 14:11:46 -0500
Probably not if you expect to be able to recover the databases. It is extremely unlikely that the data files would be in a consistent state at the time of the dump. The same is true of using tar on
Author: Benjamin Lewis <bhlewis AT pythia.itsp.purdue DOT edu>
Date: Tue, 15 Apr 2003 14:31:51 -0500
I didn't even notice that it wasn't postgres that you typed! :) It shouldn't* hurt the data files to dump them while the database is open. I would still avoid doing so because you would be taking ti