Export Firebird database to sql

mysql phpmyadmin firebird ibexpert
Frank Luke picture Frank Luke · Nov 9, 2013 · Viewed 23.2k times · Source

I have several databases in Firebird using IBExpert as the GUI admin. I am changing over to MySQL. I can use IBExpert to backup the database (which gives me the full structure and data) but the gbak format can't be read by phpMyAdmin. PhpMyAdmin has an export command that dumps the data and/or structure of the active database to an sql file. Is it possible to do something similar with IBExpert?

Answer

Mark Rotteveel picture Mark Rotteveel · Nov 9, 2013

You can use the FBExport tool to generate a dump with inserts. However I am not sure if it is still maintained and works with the latest Firebird versions (it says it was tested against Firebird 1.0 - 2.1).

See Export data from Firebird into pure SQL inserts/ export data from Firebird to MySQL for an example of how to use this tool:

$> FBExport.exe -D "c:\DB\WL.FDB" -U user –P password -Si -V TEST -F test.out

Where:
Si – means “export to SQL inserts” format
V – table name to export
F – output filename

Related questions

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More
Setting up foreign keys in phpMyAdmin?

I'm setting up a database using phpMyAdmin. I have two tables (foo and bar), indexed on their primary keys. I am trying to create a relational table (foo_bar) between them, using their primary keys as foreign keys. I created …

Read More