Subject Re: [firebird-support] can I copy database file from Windows 32bit to Linux 32bit as is? And from OSX for x86? And from OSX for PPC?
Author Helen Borrie
At 05:22 AM 4/04/2007, you wrote:
>Hello,
>
>I would like to know whether .fdb files are CPU endianess independant.

No.


>I.e. can I safely copy .fdb file from 32Bit Windows to 32bit linux (both
>running on x86)?

Yes.


>Can I copy from MacOSX (for x86) to 32bit linux?

Yes.


>Can I copy from MacOSX (for PPC) to 32bit linux (x86)?

No.


>All such copying can be done for mysql and sqlite databases (but not for
>postgresql). What about Firebird?

Use gbak -b -t on the originating server to create a transportable
backup. Then use gbak -c on the new server to recreate the database
in the incompatible environment.

It's a good idea to do it even if the source and destination are
Endian-compatible, so the DB starts life in its new home all squeaky
clean and garbage-free.

./heLen