Subject RE: [firebird-support] gfix params
Author Kevin Stanton
Here is the report:
I ran the -v and then the -m.
-m reported:
Number of record level errors: 3
Number of index page errors: 50
Number of database page errors: 3813

Any way to decipher/detail this?
Currently trying a backup and restore.

Thanks for all the help, this list is great.


-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Wednesday, March 03, 2004 3:07 PM
Subject: RE: [firebird-support] gfix params

> Thank you for your quick reply!
> I tried to backup and it seems to bomb out at one table.
> Here's what I tried
> set isc_user=myuser
> set isc_password=password
> gfix -v -mend "e:\ib databases\luimber\lumber.gdb"
> I get incompatible switch combination.
> Kevin

you don't use -m and -v together
use -m to mark corrupt records unavailable - then try to backup again
-v releases unallocated pages and provides a report - you can do this
you get a good backup

The steps I would recommend
1. Ensure no connection to the db are current - by renaming the file at OS
level. (if you can't rename then there's a connection open - close it)
2. Copy the file to another name so you have an exact copy the corrupt db.
3. Run gfix -m on the db - hopefully you get a backup - if -m doesn't work
try -m -i (which ignores checksum errors)
4. restore to yet another name - hopefully you get a good restore


Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]