How does gbak backup and restore work in Firebird?

How does gbak backup and restore work in Firebird?

GBAK is Firebird’s command line tool for online backup and restore of a complete database. For backups, is the database you want to back up, is the file name of the backup file. The usual extension is .fbk for Firebird and .gbk for InterBase. Only SYSDBA or the database owner can perform a backup.

Which is the backup file in restore mode?

In restore mode source is an existing backup file and target is the path to a firebird database. If source is “stdin”, the backup data is expected on the standard input. Most options can be abbreviated.

What should be the name of a restored database file?

Name of a storage device or backup file from which to restore. On UNIX, this can also be stdin, in which case gbak reads input from the standard input (usually a pipe). The name of a restored database file. The only permissible unit for a restored database file is database pages; minimum value is 200.

When to use sync or direct when restoring a database?

Use to validate the database when restoring it. Overrides a database write mode. The “write” mode is preserved during a backup/restore lifecycle. sync enables forced writes; async enables buffered writes; direct enables direct I/O.

GBAK is Firebird’s command line tool for online backup and restore of a complete database. GBAK is able to perform a backup while the database is running. There is no need to shut down the database during a GBAK backup.

Do you shut down the database during a gbak backup?

There is no need to shut down the database during a GBAK backup. GBAK will create a consistent snapshot of the database at the time it starts running. You will, however, notice a perfomance degradation during the backup, so it is a good idea to backup at night.

How to access the security database in gbak?

Its name is now security2.fdb The only way to access the security database is via the Service Manager. As GBAK can also use the Service Manager (Option -se), you can run a backup using this option. However, the backup file will also be written to the server machine.

How to get the version of gbakonly in Firebird?

To obtain the version of gbakonly, run the command as follows: tux> gbak -z gbak:gbak version LI-V2.5.0.26074 Firebird 2.5 gbak: ERROR:requires both input and output filenames gbak:Exiting before completion due to errors tux> echo $? 1