Hi Milan,

try this :

> gfix -mend -full -ignore database.fdb

Next, check if there's still errors :

> gfix -v -full yourdb.fdb

Do your backup :

> gbak -backup -v -ignore yourdb.fdb yourdb.fbk

If there's still an error :

> gbak -backup -v -ignore -garbage -limbo yourdb.fdb yourdb.fbk

If ,at this point, you're still unable to backup/restore. Copy your
database on a different machine and repeat the same actions.
It should work (at least for me, it saved me ..)

Greg

Le 17/11/2010 14:22, Milan Babuskov a écrit :

>
> 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
> ==================================
>
>

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