. 26 7. Gbak Caveats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 7.1. Gbak Default Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 7.4. Gbak log file Cannot Be Overwritten . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 Table of Contents 1 Chapter 1. Introduction Gbak is one of the database backup and restore utilities supplied with Firebird. In Firebird 1.5 it is

Firebird 1.5 Error Codes Firebird 1.5 Error Codes from msg.gbak, release sources SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 100 335544338 from_no_match identifiers are not allowed -901 336330753 gbak_unknown_switch Found unknown switch -901 336330754 gbak_page_size_missing Page size parameter missing -901 336330755 gbak_page_size_toobig Page size specified -901 336330756 gbak_redir_ouput_missing Redirect location for output is not specified -901 336330757 gbak_switches_conflict Conflicting switches for backup/restore -901 336330758 gbak_unknown_device

Unsigned short integer expected -842 335544712 expec_positive Positive value expected -901 336330753 gbak_unknown_switch Found unknown switch -901 336920577 gstat_unknown_switch Found unknown switch -901 Invalid database key -901 336920578 gstat_retry Please retry, giving a database name -901 336330754 gbak_page_size_missing Page size parameter missing -901 335740930 gfix_invalid_sw Invalid switch %s -901 -901 336330755 gbak_page_size_toobig Page size specified (%ld) greater than limit (16384 bytes) -901 336920580 gstat_unexpected_eof Unexpected end of database file. -901 336330756 gbak_redir_ouput_missing

value expected -901 335740929 gfix_db_name Data base file name (@1) already given -901 336330753 gbak_unknown_switch Found unknown switch -901 336920577 gstat_unknown_switch Found unknown switch -901 -901 336986114 fbsvcmgr_bad_wm Wrong value for write mode Firebird 2.1 Error Codes -901 336330754 gbak_page_size_missing Page size parameter missing -901 336920578 gstat_retry Please retry, giving a database space -901 336920579 gstat_wrong_ods Wrong ODS version, expected @1, encountered @2 -901 336330755 gbak_page_size_toobig Page size specified (@1) greater than limit (16384 bytes) -901 335740932 gfix_incmp_sw

on single-file databases. Making a safe backup with the gbak utility remains possible at all times, although it is not recommended to run gbak while the database is in LOCKED or MERGE state. Examples counter. To reset the metadata change counter You should back up and restore the database using the gbak utility. The ADD Clause With the ADD clause you can add a new column or a new table constraint. an administrator can use to suppress the automatic firing of database triggers. So far, they are: gbak -nodbtriggers isql -nodbtriggers nbackup -T Two-phase Commit In a two-phase commit scenario, TRANSACTION

security4.fdb gbak -user sysdba -b {path}security4.fdb security4.fbk # or using the security.db alias gbak -user sysdba -b security.db securitydb.fbk # or using XNET (Windows only) gbak -user sysdba -pas the backup of the first step as the security database gbak -user sysdba -c security4.fbk {path}security5.fdb # or using the security.db alias gbak -user sysdba -c securitydb.fbk security.db Contrary to Various files $(install)/doc Firebird server firebird $(install)/bin Command-line tools isql, gbak, nbackup, gfix, gstat, etc. $(install)/bin Plugins libEngine13.so, libSrp.so, libudr_engine.so,

Firebird server fbserver (SS) or fb_inet_ server (CS) /bin Command-line tools isql, gbak, nbackup, gsec, gfix, gstat, etc. /bin Sample database employee.fdb /examples/ server fbserver.exe (SS) or fb_in- et_server.exe (CS) \bin Command-line tools isql.exe, gbak.exe, nback- up.exe, gsec.exe, gfix.exe, gstat.exe, etc. \bin Sample database employee your data Backup Firebird comes with two utilities for backing up and restoring your databases: gbak and nbackup (note: nbackup is broken in 2.1; fixed with errors in 2.1.1; completely fixed in 2.1.2)

..................................................................................... 8 Change to gbak -R Semantics .................................................................................... now the only route. You can employ the - se[rvice] hostname:service_mgr switch when invoking the gbak utility for this purpose. Non-SYSDBA users no longer can see other users' accounts in the security you should create a gbak backup of your old security.fdb (from v.1.5) or isc4.gdb (from v.1.0) using the old server's version of gbak and then restore it using the Firebird 2.0 gbak. Important You must

C:\Program Files\Firebird Firebird server ibserver.exe (SS only) \bin Command-line tools gbak.exe, gfix.exe, gstat.exe, etc. \bin Sample database employee.gdb \ex- amples /opt/interbase Firebird server ibserver (SS) or gds_inet_server (CS) /bin Command-line tools gbak, gfix, gstat, etc. /bin Sample database employee.gdb /ex- amples UDF libraries thread-safe way to connect to a local server. For using single instances of the command-line tools (gsec, gbak etc.) it works just fine. By contrast, direct database connections - even multiple - under a Linux

non-nullable. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 Gbak -n restoring NOT NULL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . backup-restore cycle will fix this, provided that at least the restore is executed with Firebird 2’s gbak! • Firebird 2.0 has a bug that causes the NULLS FIRST|LAST directive to fail under certain circumstances set. • If the damage has already been done and you find yourself with an unrestorable backup, use gbak's -n switch to ignore validity constraints when restoring. Then fix the data and reinstate the constraints