Subject | Re: [firebird-support] Not a valid database |
---|---|
Author | Helen Borrie |
Post date | 2016-06-21T03:43:21Z |
Hello Seyeong,
Tuesday, June 21, 2016, 12:52:51 PM, you wrote:
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.
Helen
Tuesday, June 21, 2016, 12:52:51 PM, you wrote:
> SQL>> connect "/home/user/a.fdb" user '*******' password '**********';My top suspicion is that you have a backup file there that you have
> 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.
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.
Helen