Subject Re: metadata extract/recreate script vs gbak backup/restore
Author pfyag
--- In ib-support@y..., "Thomas Steinmaurer" <ts@i...> wrote:

> > I have a problem with a database:
> > - gfix -v -full reports no problem
> > - gbak can backup the database with or without data with no
> > problems
> > - gbak can't restore the database without the engine crashing
> > (with or without data in the backup)
> >
> > The restore have been tried on Interbase 6 on WinNT, on Firebird
> > Linux and on Firebird 1.0 Linux. All crashing at the
> > end, before going home. The backups made from both Firebird
> > versions.
> What do mean with "crashing". Does the Firebird Server crash or does
> it seem that the last stage is running "infinite"? You know that on

The interbase.log showing that the server terminated abnormally (-1)
and ibguard restarting it. gbak does return something about connection
lost with server at localhost or something similar.

> restore all indizes are rebuilt and this can take a time on a big
> database? How much free disk space do you have on the partition
> where the database is restored?

I've got between 3 and 3.5 gigs of free space on that partition and
the database takes less than 20 megs.

> > Now, I've been able to extract all the metadata and data into a
> > script to recreate the database using IBExpert. I did recreate
> > the database with that script and I can now backup/restore it.
> > Everything I tested seems to work as intended. Now, is this
> > supposed to create an equivalent database or will there be
> > something missing in it? How can I compare the two databases
> > and make sure they are the same before I switch to the new
> > "fixed" one?
> How did you extract all the metadata? What tool have you used?
> Getting a working, *complete* script file for a complex database
> (for example having many views depending on each other , ...)
> can be really tricky ;-).

As mentionned earlier, I used IBExpert for this. Ok, it may not be
clear that it wasn't used only to recreate the database.

> But pretty sure you have lost BLOB data when exporting data into a
> script file.

IBExpert did create a blob file and referenced it in the script. Those
blobs I checked were in the new database and seemed to contain the
right data; I didn't do byte comparison on the blob fields yet.


Patrice Fournier