| Subject | RE: [firebird-support] unavailable database |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-01-16T00:20:34Z |
At 10:34 AM 16/01/2008, you wrote:
1) the server isn't running; or
2) the server is running but it is unable to locate the named database file
3) the server is running but it is unable to CREATE the named database file
Now, from your original posting, gbak found the *backup file* OK. (It's just a file!) Where it fell over was the point at which it had to connect to the server and create a *database*. To create a database it first had to create a file with the minimal header info to enable it to be connected to as a database so it's a reasonable guess that it may have got that far before it bumped into the database-related problem. Did you check whether any of those *files* were created? gbak -c won't work if the files already exist, so delete them before you try again.
You wrote:
-- that's progress, since it's telling you that gbak did make contact with security.gdb but that it didn't find the supplied username and password combo in there. Where are you migrating from? Are you trying to use login credentials that don't exist in the Fb 1.5 server?
./heLen
>Thanks; I did try with localhost:I:\Firebird\s6.fbk etc.At connection time, "Unavailable database" means one of two things:
>
>But that gave me the same error message.
>
>Tried your command text now, and at first I thought there was some progress
>as I got a message about wrong username/password, but I now get
>
>The same error message again.
1) the server isn't running; or
2) the server is running but it is unable to locate the named database file
3) the server is running but it is unable to CREATE the named database file
Now, from your original posting, gbak found the *backup file* OK. (It's just a file!) Where it fell over was the point at which it had to connect to the server and create a *database*. To create a database it first had to create a file with the minimal header info to enable it to be connected to as a database so it's a reasonable guess that it may have got that far before it bumped into the database-related problem. Did you check whether any of those *files* were created? gbak -c won't work if the files already exist, so delete them before you try again.
>> why are you restoring to multiple files on an XP system? is it becauseFAT partitions had file size limits imposed by the operating system (2 GB or 4 GB, depending on the OS version that created them). If your partitions are NTFS partitions created by Winnt 5 (that's Win2K or XP) then there's no need to split up your databases. (But you still can, if you want to...)
>disk I: is a fat32 partition?
>
>No, I just a normal, plain external HD.
>
>I was used to this way of restoring from using Interbase 5.6
>Will try now with only one target file specified....not that restoring as a single-file database will make a difference to the problem you're having. You need to figure out why the server isn't accepting connection requests.
You wrote:
> Tried your command text now, and at first I thought there was some progressas I got a message about wrong username/password
-- that's progress, since it's telling you that gbak did make contact with security.gdb but that it didn't find the supplied username and password combo in there. Where are you migrating from? Are you trying to use login credentials that don't exist in the Fb 1.5 server?
./heLen