Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)
Friday, July 28, 2017, 9:03:19 PM, robert rottermann wrote: > I proceeded as Helene suggested > I executed gbak. > However this produced zillions of warnings of the form > gback: do not recognize table attribute 0 -- continuing > this goes on now for some 15 minutes. > A database VAS.FDB was created > I can open it from my linux box using flamerobin. > The tables seem to exist all, their structure is ok as far as I can > judge from a first glance. > But alas, they are empty!! > please advice. Something is wrong with that backup. In your original message, you said: >when I do [a restore) on my linux box >sudo gbak -c VAS.bak vas_db/VAS.fdb >this seems to work fine (alltough i can not use the result) Questions: 1. What did you mean "I can not use the result" ? 2. Are you able to connect to the original database on Linux and see data in the tables? Meaning - do you have a "good" database somewhere? 3. On Linux, what information does FlameRobin provide about the on-disk structure and the status of the database? (You can also get this information using gstat -h, or using the SHOW DATABASE command in isql.) 4. Have you tried making your own gbak backup of the "good" database on the Linux box? 5. Have you tried file-copying the good database onto the Windows box and connecting to it? Helen
RE: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)
Robert, > the restore operation is running now for some minutes. > However I get very many (some thousand ??) messages of the form: > > gbak: do not recognize table attribute 0 -- continuing > > does this point to a serious problem or can I safely ignore it? You have a serious problem. Sean
Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)
Thank you Helen, I had a disk crash so I was absorbed restoring .. gbak -c d:\vas_db\/VAS.bak localhost:d:\vas_db\VAS.fdb -user sysdba -password yourpwd your proposal seems to work. the restore operation is running now for some minutes. However I get very many (some thousand ??) messages of the form: gbak: do not recognize table attribute 0 -- continuing does this point to a serious problem or can I safely ignore it? thanks again robert
Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)
Hi there, I proceeded as Helene suggested I executed gbak. However this produced zillions of warnings of the form gback: do not recognize table attribute 0 -- continuing this goes on now for some 15 minutes. A database VAS.FDB was created I can open it from my linux box using flamerobin. The tables seem to exist all, their structure is ok as far as I can judge from a first glance. But alas, they are empty!! please advice. robert
Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)
Hi there, I proceded as Helene suggested I executed gbak. However this produced zillions of warnings of the form gback: do not recognize table attribute 0 -- continuing this goes on now for some 15 minutes. A database VAS.FDB I can open it from my linux box using flamerobin. The tables seem to exist all, their structure is ok as far as I can udge from a first glance. But allas, they are empty!! please addvice. robert
Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)
Hello robert, Tuesday, July 25, 2017, 4:32:12 PM, you wrote: > When I try to unpack it using the following command: > c:\Program Files\Firebird..\bin\gback.exe -c VAS.bak VAS.fdb 1. Make sure the server is running. 2. You need the file path and, if using Classic mode, the hostname. > This produces errors: > gbak: Error: unavailable database VAS > gbak: Error: failed create database VAS > gbak: Error: Exiting before completion due to errors. > when I do the same on my linux box > sudo gbak -c VAS.bak vas_db/VAS.fdb > this seems to work fine (alltough i can not use the result) > can somebody please tell me, how to unpack that file on windos? Let's assume you want the database to be in a directory called "vas_db" and you have created this directory on drive D. For simplicity, let's say you have placed the backup there as well. The backup is just a FILE so you don't need the host name for that. You are restoring to a DATABASE and for that you need a host name on Classic. You want gbak -c d:\vas_db\/VAS.bak localhost:d:\vas_db\VAS.fdb -user sysdba -password yourpwd The default sysdba password on a new installation is masterke, in case you don't know that already. The drive MUST be one that is physically connected to the host box. It can't be a share or anything like that. Helen
[firebird-support] unpacking backup with firebird version 1.5 (windows 7)
Hi there, we are in the process of restructuring a system running on windows XP. It uses firebird version 1.5. The person that created the system is not available anymore .. some times ago, i got the database and installed it on a win7 box. Now I would like to get the newest data from the daily back which is created using gbak. When I try to unpack it using the following command: c:\Program Files\Firebird..\bin\gback.exe -c VAS.bak VAS.fdb This produces errors: gbak: Error: unavailable database VAS gbak: Error: failed create database VAS gbak: Error: Exiting before completion due to errors. when I do the same on my linux box sudo gbak -c VAS.bak vas_db/VAS.fdb this seems to work fine (alltough i can not use the result) can somebody please tell me, how to unpack that file on windos? thanks robert