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

 

Hi,

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

regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------
Od: "Seyeong Jeong wmbdmw@gmail.com [firebird-support]" <firebird-support@yahoogroups.com>
Data: 21.06.2016 05:58 (GMT+01:00)
Do: firebird-support@yahoogroups.com
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@iinet.net.au [firebird-support] <firebird-support@yahoogroups.com> 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.

Helen

--

/Da Capo/

__._,_.___

---

Posted by: liviuslivius <liviuslivius@poczta.onet.pl>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___