Subject | Re: How do I backup FB 2.0 security2.fdb? |
---|---|
Author | red_october_canada |
Post date | 2007-03-20T21:10:37Z |
> Try TIBBackupService component (from InterBase Admin page)Thanks Ivan
Hey, I made a little utility in D7 to accomplish this, using the
suggested component, and it works ok.
However, I stumbled upon
http://www.destructor.de/firebird/gbak.htm
which states that I can use gbak with the -se dbserver:service_mgr
option to accomplish the same thing. However, I can't make this work.
I substitute "dbserver" with "localhost" and come up with a command
string like this:
gbak -v -t -user sysdba -password bubbles -se localhost:service_mgr
"C:\Program Files\Firebird\Firebird_2_0\security2.fdb"
"C:\firebird_bk\Security2.fbk"
This always gives me the error: I/O error for file "C:\Program"
I tried this also:
gbak -v -t -user sysdba -password bubbles -se localhost:service_mgr
"127.0.0.1:C:\Program Files\Firebird\Firebird_2_0\security2.fdb"
"C:\firebird_bk\Security2.fbk"
This produces the error:
Connection rejected by remote interface.
-----------------------------------------
SOLUTION FOUND:
I just made an alias (sec2) in the aliases.conf file that points to
the security2.fdb and changed the command to:
gbak -v -t -user sysdba -password bubbles -se localhost:service_mgr
sec2 "C:\firebird_bk\Security2.fbk"
It now works fine. So much for my little D7 utility <tears,sniff>
I hope no one minds me posting the complete solution here, for anyone
who may have run into this too.