Subject | Cannot restore mend-ed database |
---|---|
Author | Milan Babuskov |
Post date | 2010-11-17T13:22:53Z |
Hi,
I have a corrupt database, which I cannot backup. I run gfix -mend, it
seems to report that it's ok, but I get a weird error message when
trying to backup:
root@datafields:/baze# /opt/firebird/bin/gfix -mend fix.fdb
Summary of validation errors
Number of record level errors : 2
Number of index page errors : 2
root@datafields:/baze# /opt/firebird/bin/gbak -b fix.fdb fix.fbk
gbak: ERROR:I/O error for file "/baze/fix.fdb"
gbak: ERROR: Error while trying to read from file
gbak: ERROR: No such file or directory
gbak:Exiting before completion due to errors
However, the file is there. I checked dmesg and messages, the system
does not report any problems with the hard disk. I even tried to copy
the file to another computer, without luck.
I tried to copy the data to an empty database, but select on one of
crucial tables fails.
Any ideas what to do next?
Thanks.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
I have a corrupt database, which I cannot backup. I run gfix -mend, it
seems to report that it's ok, but I get a weird error message when
trying to backup:
root@datafields:/baze# /opt/firebird/bin/gfix -mend fix.fdb
Summary of validation errors
Number of record level errors : 2
Number of index page errors : 2
root@datafields:/baze# /opt/firebird/bin/gbak -b fix.fdb fix.fbk
gbak: ERROR:I/O error for file "/baze/fix.fdb"
gbak: ERROR: Error while trying to read from file
gbak: ERROR: No such file or directory
gbak:Exiting before completion due to errors
However, the file is there. I checked dmesg and messages, the system
does not report any problems with the hard disk. I even tried to copy
the file to another computer, without luck.
I tried to copy the data to an empty database, but select on one of
crucial tables fails.
Any ideas what to do next?
Thanks.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================