Subject Re: [firebird-support] Empty tables after restore?
Author Bradley Tate
Helen,

Thanks, but that's not it. I've done the restore on several different
boxes, with stupid names so and they can't possibly be being accessed
and all give the same problem. I can watch (-v) the restore and
thousands of records are going in to tables. They just won't come out
again. gfix -v -full on the original gdb comes back with no complaints -
no comments at all, actually. Not being able to get a working backup is
scary. Anything I haven't tried that springs to mind?



Helen Borrie wrote:

> At 11:20 AM 24/01/2004 +1100, you wrote:
> >Hi,
> >
> >We're having an unusual problem. We have a large-ish 3G+ gdb which
> >appears to back-up happily but when it is restored the tables are empty.
> >I've run gfix -v -n on the original and nothing was reported.
> >
> >Does anyone have any clues about why this might be happening or what we
> >should look for?
> >
> >Linux, FB1.0.3
>
> Best guess is that you are trying to access the database before the
> restore
> is finished - yes, you can do that and do I need to mention that this
> is a
> very hairy practice? Restore actually does a full rebuild of the
> database,
> starting with metadata and later adding the data.
>
> /hb
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>