Subject | RE: [firebird-support] HELP! Unavailable database whatever I do! |
---|---|
Author | Salim Naufal |
Post date | 2003-11-04T22:45:12Z |
Hi David,
Yes, you can use the -ignore switch.
This is the command:
gfix -mend -ignore -user sysdba -password masterkey <your database>
I also have a small windows program you can download. It uses the IBX
components that connect to the service API of Firebird (Superserver only).
It does the whole procedure: Shutdown database, gfix -mend -ignore, backup
then restore.
You can download it at:
http://www.paperbricks.com/downloads/en/RepairDatabase.zip (about 385 KB)
I can also upload the sources if interested.
Salim
-----Original Message-----
From: dhay@... [mailto:dhay@...]
Sent: Tuesday, November 04, 2003 8:08 PM
...
Now trying to fix old database which I saved off. I ran the gfix command
you suggested below, but I get the following error:
database file appears corrupt ()
-bad checksum
-checksum error on database page 36609
Don't know much about gfix. Should I try the -ignore option too, to ignore
the checksum error?
Is there any detailed documentation for gfix anywhere?
Many thanks,
David
Yes, you can use the -ignore switch.
This is the command:
gfix -mend -ignore -user sysdba -password masterkey <your database>
I also have a small windows program you can download. It uses the IBX
components that connect to the service API of Firebird (Superserver only).
It does the whole procedure: Shutdown database, gfix -mend -ignore, backup
then restore.
You can download it at:
http://www.paperbricks.com/downloads/en/RepairDatabase.zip (about 385 KB)
I can also upload the sources if interested.
Salim
-----Original Message-----
From: dhay@... [mailto:dhay@...]
Sent: Tuesday, November 04, 2003 8:08 PM
...
Now trying to fix old database which I saved off. I ran the gfix command
you suggested below, but I get the following error:
database file appears corrupt ()
-bad checksum
-checksum error on database page 36609
Don't know much about gfix. Should I try the -ignore option too, to ignore
the checksum error?
Is there any detailed documentation for gfix anywhere?
Many thanks,
David