Subject ODP: Re: [firebird-support] Not a valid database
Author liviuslivius

first what i try in this situation is moving not database file only its transportable backup and restore it on target OS.

Karol Bieniaszewski

-------- Oryginalna wiadomość --------
Od: "Seyeong Jeong wmbdmw@... [firebird-support]" <>
Data: 21.06.2016 05:58 (GMT+01:00)
Temat: Re: [firebird-support] Not a valid database


Hi Halen,

Thanks for your suggestion. When I compare md5sums of the file a.fdb on both OSes, and they are exactly the same. This was one of the first things I tried...

On Tue, Jun 21, 2016 at 3:43 PM, Helen Borrie helebor@... [firebird-support] <> wrote:

Hello Seyeong,

Tuesday, June 21, 2016, 12:52:51 PM, you wrote:

> SQL>> connect "/home/user/a.fdb" user '*******' password '**********'; 

> Statement failed, SQLSTATE = HY000
> file /home/user/a.fdb is not a valid database

> Note that the example file, employee.fdb is accessible.

> Again, the same file is perfectly accessible on Windows with FlameRobin.

My top suspicion is that you have a backup file there that you have
inadvertently named with the ."fdb" extension. I suggest you try
again, this time just making certain about those file names when you
back up and restore.

BTW, this error has nothing to do with the file name: it is raised
when the engine finds the named file but can't find a database header
page in it.

Also, Firebird doesn't care about extensions at all. ".fdb" for
databases and ".fbk" for backup files are just a convention.


/Da Capo/