Commented by: Alice F. Bird (firebirds)

Date: 2005-10-19 03:47
Sender: parmaja
Logged In: YES
user_id=720012

GBAK is client side, thanks for you :) i can use
ShellExecute for it, resolving my problem.
But for that i must install firebird server on the client
computer, or publish gbak.exe with my setup.
i am using delphi isc_ api to use backup service it make
backup file only on server not in client side, that the one,
the two, when i received as stream not file i can compress
it more with LZMA or somthing else before when saving it to file

It is usefull feature for my lazy customers :)

Commented by: Alice F. Bird (firebirds)

Date: 2005-10-18 06:30
Sender: robocop
Logged In: YES
user_id=62823

Why can't your customers use gbak? Gbak has existed for more
than 15 years and creates client-side backups.

Commented by: PizzaProgram Ltd. (szakilaci)

This would solve 2 problems:
- a security risk by being able to encrypt (and compress) in real time the FBK file
- no need to install / locate gbak file. (It's hard to locate the proper exe file.)

Commented by: Artem Petkevych (artem)

Wasn't this made in Firebird 2.5.2 ? "Back Up to or Restore from a Remote Backup File".
Shouldn't this issue be marked as Resolved?

Commented by: @dyemanov

Closed in favor of CORE2666.

Commented by: PizzaProgram Ltd. (szakilaci)

I would like to share my experience with everyone trying to encrypt and compress a FBK file on the fly (without intermediate file):

I have tried many different free, undecryptable compressors, but only http://www.7zip.org worked for me yet, because it has an extra -si option to accept a stream as an input.
(Use v9.20 stable DOS version only ! ... alpha versions having currently encryption Bugs !)

BACKUP:
@gbak.exe -B -user sysdba -pas masterkey DEMO.FDB stdout | 7z.exe a -siSOMENAME.FBK -t7z -mx=3 -mtc=on -mhe=on -pMYPASSWORD COMPRESSEDFILE.7z

RESTORE:
@7z.exe e -so -pMYPASSWORD -t7z COMPRESSEDFILE.7z | gbak -c -user sysdba -pas masterkey stdin DEMO2.fdb

Hint:
I'm calling this from Delphi, and there ShellExecute nor other "DOS calling procedures" did not run it properly. Had to use an intermediate bach file (RUNME.BAT) and passed parameters, like:
@"C:\Program Files\Firebird\Firebird_2_1\bin\gbak.exe" -B -T -V -user %1 -password %2 %3 stdout | "E:\MyFolder\7za.exe" a -siCOMPRESSEDFILE.fbk -t7z -mx=3 -mtc=on -mhe=on -p=%4 %5

Someone could put this on the website's FAQ maybe?