Amanda-Users

Re: Using dump on running databases

2003-04-15 15:05:51
Subject: Re: Using dump on running databases
From: "Chad Morland" <chad.morland AT inquent DOT com>
To: "Frank Smith" <fsmith AT hoovers DOT com>, <Amanda-users AT amanda DOT org>
Date: Tue, 15 Apr 2003 13:44:27 -0400
> --On Tuesday, April 15, 2003 12:42:01 -0400 Chad Morland
<chad.morland AT inquent DOT com> wrote:
>
> > 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 from
running
> the dump, except possibly slowing down the database.  However, the
resulting
> dump image would most likely be useless in restoring the database.
>    Generally, you either need to shut down the database and then do
the dump,
> or export all the data from the database to file(s) and back them up.
>

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 make sure that I had no problems with the dump
image itself. Thanks.

-CM


<Prev in Thread] Current Thread [Next in Thread>