External Tools ..... 26 7. Gbak Caveats ..... 29 7.1. Gbak Default Mode ..... 29 7.2. Normal Versus Privileged Users ..... 29 7.3. Silent Running? ..... 29 7.4. Gbak log file Cannot Be Overwritten Appendix A: Document history ..... 31 Appendix B: License notice ..... 33 ### Chapter 1. Introduction Gbak is one of the database backup and restore utilities supplied with Firebird. In Firebird 1.5 it is discuss: • Command-line options for gbak. • gbak commands and their parameters. • Running gbak in backup or restore modes. • Some caveats, gotchas and foibles of gbak. ### Chapter 2. Command-line Options

systems. Gsplit is a filter utility introduced with Interbase 5.0 which allows the output file from the gbak utility (when backing up a database) to be split into a number of chunks, or a number of chunks to together and used to restore a database. Up until Interbase 5.0, dump files were limited to 2 Gb by the gbak utility itself — even if running on a system which allowed files to be 4 Gb. Coming up in the remainder gsplit is no longer required as gbak allows large files to be split directly. The details for gsplit given here are for reference only and you are advised to use gbak to split large backup files even

seit Firebird 2.0 inkludiert ist. Es bietet Möglichkeiten, die in dem bekannten Firebird Backup-Tool gbak— bereits in Firebird vorhandenes Backup-Tool—nicht vorhanden sind. Es ersetzt jedoch nicht letzteres in einer neuen Datenbank wiederherstellen. In dieser Hinsicht unterscheidet sich nbackup nicht von gbak. #### 2.1. Vorteile von nbackup • Beide Modi: hohe Geschwindigkeit (so hoch wie es Hardware und • nbackup wird kein Sweep und auch keine Verkleinerung Ihrer Datenbank durchführen, so wie das bei gbak im Falle einer Sicherung mit anschließender Wiederherstellung ist. • Sie können mit einem nbacku

is possible to clear out old rolled back transactions' garbage with a database backup by gbak tool. Gbak reads every table sequentially and thus visits every row in every table. Applications which also Practical tips for databases recovery In practice, to recover database it is necessary to use gfix and gbak tools. First of all, before the recovery, it is necessary to create a file copy of the corrupted of the corrupted database using gbak command: gbak -backup -ignore database_name backup1.fbk gbak -create backup1.fbk new_database_name If backup and restore with gbak completed successfully, the database

### Firebird 1.5 Error Codes from msg.gbak, release sources |SQLCODE|GDCODE|SYMBOL|TEXT| |---|---|---|---| |101|335544366|segment|Segment buffer length shorter than expected| |100|335544338|from\_no\_match|No 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\_output\_missing|Redirect location for output is not specified| |-901|336330757|gbak\_switches\_conflict|Conflicting switches for backup/restore| |-901|336330758|gbak\_unknown\_device|Device

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| 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 |-901|336330755|gbak\_page\_size\_tobig|Page size specified (%ld) greater than limit (16384 bytes)| |-901|336920580|gstat\_unexpected\_eof|Unexpected end of database file.| |-901|336330756|gbak\_redir\_out

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| valid database key| |-901|336986114|fbsvcmgr\_bad\_wm|Wrong value for write mode| |-901|336330754|gbak\_page\_size\_missing|Page size parameter missing| |---|---|---|---| |-901|336920578|gstat\_retry|Please |-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|gf

резервных копий средствами файловой системы. (При этом безопасное резервное копирование с помощью утилиты gbak остаётся доступным). ## Изменение набора символов по умолчанию Предложение SET DEFAULT CHARACTER счётчика форматов необходимо сделать резервное копирование и восстановление базы данных (утилитой gbak). ## Предложение ADD Предложение ADD позволяет добавить новый столбец или новое ограничение таблицы утилиты командной строки Firebird были добавлены новые ключи для отключения триггеров на базу данных: gbak -nodbtriggers isql -nodbtriggers nbackup -T Эти ключи могут использоваться только SYSDBA или владельцем

b9bb6554f2926/p87_1.jpg) 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 client • for a DISCONNECT trigger, exceptions are not reported. The connection is broken as intended. gbak -nodbtriggers isql -nodbtriggers nbackup -T TRANSACTION triggers are executed within the 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 serverfirebird$(install)/binCommand-line toolsisql, gbak, nbackup, gfix, gstat, etc.$(install)/binPluginslibEngine13.so