Jump to content

Problem with Firebird databases


Guest

Recommended Posts

The first thing you would need to do is confirm that your database is corrupted. First make a backup and then restore it: you will need to use the GBAK tool (this tool is part of the Firebird installer).

Then execute from the command line:

1. Create backup copy:

GBAK -user SYSDBA -password masterkey -b corrupt.fdb corrupt.fbk 

2. Restore backup:

GBAK -user SYSDBA -password masterkey -C corrup.fbk restored.fdb

If the database is corrupt, you will receive an error

Then in order to recuperate the database you need to use the following command (also included on Firebird installer):

GFIX -user SYSDBA -password masterkey -mend -full -ignore corrupt.fdb 

Using this command you will be able to get a complet backup, if that is not the case you will have to make a backup ignoring its inconsistencies:

GBAK -user SYSDBA -password masterkey -IGNORE -b corrupt.fdb corrupt.fbk 

If this command is successful restoring the backend you will have the original database on a consistent state.

Let me know if you could solve it!

Kind Regards

Link to comment
Share on other sites

  • 1 month later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...