Subject Problem restoring database using gbak
Author agarzotto
Trying to migrate from Interbase 6.0.1 to Firebird 1.5, we exported
the current database (about 4.5GB) and tried to import it using the
gbak utility of Firebird 1.5:

/opt/firebird/bin/gbak -v -C -p 8192 -bu 8192 database.gbk database.
gdb

This results in:

...
bak: restoring privilege for user ADARVO
gbak: restoring privilege for user ADARVO
gbak: restoring privilege for user ADARVO
gbak: restoring privilege for user ADARVO
gbak: creating indexes
gbak: restoring index RDB$PRIMARY77
gbak: restoring index RDB$PRIMARY73
gbak: restoring index RDB$PRIMARY65
gbak: restoring index RDB$72
gbak: restoring index RDB$PRIMARY62
gbak: cannot commit index RDB$PRIMARY61
gbak: ERROR: I/O error for file ""
gbak: ERROR: Error while trying to open file
gbak: ERROR: Permission denied
gbak: ERROR: action cancelled by trigger (3) to preserve data
integrity
gbak: ERROR: Cannot deactivate primary index
gbak: Exiting before completion due to errors

For some odd reason, transferring the .gbk to our test server on which
Firebird is also installed, did work. So we moved the db back to the
other server. We are up and running, but there is a bad feeling (do we
risk to lose data?).

Any help appreciated.

Andreas Garzotto