Re: how robust are custom dumps?

Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:

> Hi,
>
> Some 6 years ago, i had a bad experience with a custom dump. It wouldn't
> restore and my data was lost.
> I was a beginner then, and working under windows, and i wasn't on the mailing
> list yet.
> It was no critical data, we could build the database again, which was then
> easier than figuring out what exactly went wrong with the backup.
>
> Since then i have refused to trust custom dumps.
> But they do provide some very nice functionality, like restoring a single
> table.
>
> So my question is: what is your advice on custom dumps? Can i bet my life on
> them?

I think so, yes.

Early versions contains some errors with the correct order of objects
(dumping a view before the table -> error whilst restore ...)

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°