Re: Using dump on running databases
2003-04-15 15:05:51
> --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
|
|
|