. 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

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

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

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)

Server fbserver.exe (SS) oder fb_inet_server.exe (CS) \bin Kommandozeilentools isql.exe, gbak.exe, nbackup.exe, gsec. exe, gfix.exe, gstat. exe, etc. \bin Beispieldatenbank employee Firebird Server fbserver (SS) oder fb_ inet_server (CS) /bin Kommandozeilentools isql, gbak, nbackup, gsec, gfix, gstat, usw. /bin Beispieldatenbank employee.fdb /examp- Sicherung Firebird kommt mit zwei Tools für das Sichern und Wiederherstellen Ihrer Datenbanken: gbak und nbackup. Beide Tools befinden sich im bin Unterverzeichnis Ihrer Firebird Installation. Firebird