Subject | Re: [firebird-support] Backing up tables with procedures |
---|---|
Author | Alexandre Benson Smith |
Post date | 2006-03-14T19:22:19Z |
Richard Poulin wrote:
I don't know how IBExpert do the back-ups (almost sure via the services
API) and how it inform the progress as well.
Try gbak, it is very simple.
use the verbose comand (-v) to see the progress, something like
gbak server:path_to_database database.fbk -user sysdba -password
masterkey -v -t
If it does contain "finishing closing and going home" on the last line
it has some problems.
after that restore it to another plase to see if it restores ok.
gbak database.fbk server:path_to_another_database -c -user sysdba
-password masterkey -v -t
look again for the "finishing closing and going home" phrase on the last
line.
If you have any invalid procedure it should stop before the end.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Hi, being novice on Firebird, - i'm using IBexpert to backup a FirebirdHi Richard,
> table (format transportable) containing hundreds of procedures,
> generators and triggers. Restoring is ok but for the procedures! None is
> backed up. Am I misssing anything with the backup or restore options ?
> Thanks. RP
>
I don't know how IBExpert do the back-ups (almost sure via the services
API) and how it inform the progress as well.
Try gbak, it is very simple.
use the verbose comand (-v) to see the progress, something like
gbak server:path_to_database database.fbk -user sysdba -password
masterkey -v -t
If it does contain "finishing closing and going home" on the last line
it has some problems.
after that restore it to another plase to see if it restores ok.
gbak database.fbk server:path_to_another_database -c -user sysdba
-password masterkey -v -t
look again for the "finishing closing and going home" phrase on the last
line.
If you have any invalid procedure it should stop before the end.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br