Subject Re: [firebird-support] Exporting data from firebird
Author Milan Babuskov
Philip wrote:
> Is there a way to dump the data from Firebird as SQL statements, as per the mysqldump utility?

You can use FBExport tool for that. Everything except binary BLOBs can
be exported as SQL statements:

http://www.firebirdfaq.org/fbexport.php

However, it might be more efficient to use DB Workbench or similar
Windows tool to copy the data directly (if you have fast connection to
both servers). There are slight differences between Firebird and MySQL,
so if you want to keep it Linux-only, you might need to do a
find&replace (via "sed" for example) on FBExport dump file before
importing it into MySQL. It all depends on the data types used for table
columns.

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================