2010/6/25 Koenraad Lelong <k.lelong@ace-electronics.be>:

Ciro Iriarte schreef:

...

I'm replacing a old clone server running openSUSE with a PHP application connecting to Firebird to a new highend server. I've seen Firebird is available on OBS, although PHP modules for it are not.

Anyone has done a migration of with Interbase/Firebird on openSUSE/SLES/any Linux?. My first idea was to just copy the datafiles, but the old server is running i386 kernel and the new one will be x86_64, so that probably wont work... Also found out about FBExport, it has some documented drawbacks but I'm not sure if they're common or not.

I've worked with MySQL/PgSQL/Oracle/DB2 but I'm a little lost with this "new kid on the block", so any help will be appreciated.

Regards,

Hi Ciro,

I'm a big fan of Firebird so I use it when I need a database server. Not with php though, although I do want to have a try with it when I have time. And, like you experienced, if I find the php-interfaces. But I'm afraid you will have to compile it.

To transfer data from an old firebird/Interbase server to a new one, the best thing to do is to make a transportable backup. That dumps all data in a way all servers should understand. Then you restore that to the new server. I don't know how to transfer the user accounts though, maybe backing up the security database ?

I use Flamerobin to manage my firebird servers. That way you have a gui to do things like backup and restore.

HTH -- Met vriendelijke groeten, Koenraad Lelong

Thanks a lot for the insight. Regards, -- Ciro Iriarte http://cyruspy.wordpress.com -- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org