recover backup of firebird fail

0
votes

I previously asked how to make a backup of a Firebird database in

I need to backup or clone one remote firebird database or export it to Sql server

Now the backup is complete, but when I try to restore it to Firebird on my computer, I get an error.

I use this command: 

gbak -r -p 4096 -o e:\mybackup.fbk localhost:e:\bddados.fdb -user sysdba -pas masterkey

The error I receive is

gbak: ERROR:Your user name and password are not defined. Ask your database administrator to set up a Firebird login. gbak:Exiting before completion due to errors

But I test my Firebird locally with this user and password and it's ok. Does the created backup database need to specify in generate command a password or do I need to use the same of the old database?

1
backupfirebird
The password is given with "-pass" (double S). Try gbak -r -p 4096 -o e:\mybackup.fbk localhost:e:\bddados.fdb -user sysdba -pass masterkey - Duilio Juan Isola
I try it now, but has new error. gbak -r -p 4096 -o e:\mybackup.fbk localhost:e:\dados.fdb -user SYSDBA -pass masterkey gbak: ERROR:unavailable database gbak:Exiting before completion due to errors - NIZZOLA
Thank´s, it works now!! - NIZZOLA
See also the gbak documentation - Mark Rotteveel
@ValMarinov guess you are to make your comments into the answer that Nizzola would formally accept - Arioch 'The

1 Answers

2
votes

user and pas[sword] parameters should be before the path to files 

gbak -r -p 4096 -o -user sysdba -pas masterkey e:\mybackup.fbk localhost:e:\bddados.fdb

gbak documentation