Export / dump SQL from the HSQLDB base

Hi,

I would like to know if it is possible to export the HSQLDB base contents into a .sql text file for later import into MYSQL, perhaps by writing a short java app to do it?

Of course it would be great as an agiletrack feature…

PS: I can't use the above 1.0 releases on my machine (WinXP) because the application quits just after the login prompt… the log just says that the db connection has been closed…

0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
16 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
7547 [AWT-EventQueue-1] INFO : hsqldb.TrackerHSQLDatabase – Updating database from version 4…
7547 [AWT-EventQueue-1] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE role (id BIGINT NOT NULL, permissions VARCHAR, PRIMARY KEY (id))
7563 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.

The update is because I copied the database data from the previous install, but I had the same problem before copying it.

I'm afraid of being stuck with my old version, without having the ability to recover/export my data… :/