Norman Dunbar updated the gbak manual with the following:
A section on the use of stdin and stdout “file names” and how to clone
a database – on the same server – using a pipe and these “file names” to
avoid the use of a temporary intermediate dump file.
A section on carrying out remote backups and restores using the above
as well as an ssh session. This allows a remote database to be cloned to
a local server, a local database to be cloned to a remote server and a
remote database to be cloned to (another) remote server.
Further updates to document the use of the stdin and stdout file names in backups and restores. A section has been added to Gbak Caveats giving more in depth detail about these two special file names.
There is a simple change which makes restores much faster, tested with Linux 2.5 embedded restore
Two databases, with two different tables filled with 2,000,000 records:
create table t1 (n1 integer);
create table t10 (n1 integer, n2 integer, n3 integer, …, n10 integer);
It seems that many Firebird developers and administrators are not aware about command line switch -se[rvice] for gbak.exe
This switch causes gbak to backup a remote database via the service manager. This causes the backup file to be created on the remote server, so the path format and filename must be valid on the remote server. The servicename is currently always the text service_mgr.
Repairing broken Firebird database can be sometimes a bit difficult. The official tools (gfix and gbak) not always can help you so you will have to find ways to transfer data from broken database into another fresh and clean one.
There are usually only two reasons why a database can be corrupted in Firebird: 1) You copied the fdb-file while the Server was accessing it and 2) You don’t have forced writes enabled and the server shut down unexpectedly (e.g. power-outage)
Database recovery is done in four steps. Here’s how you do it:
SSH is a wonderful piece of software. I found (hum, Philippe, the CentOS package maintainer, president of the Firebird Foundation and member of the QA team of Firebird helped me to find) how to create a SSH tunnel through I can run a distant Firebird backup.