![[Topic]](/images/icons/record_topic.png) 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… :/
—Posted by Alex Pages on Apr 3, 2007
|
|
It appears the automatic database schema update is halting for some reason.
Although there is not export/import feature right now for moving between databases, the process should be pretty simple assuming the existing database can be used. It has been done for test scenarios, though it hasn't been made into a tool.
Would you be willing to send a copy of the database files so I can try to get it working? If I can recover it, I'll make a MySQL dump of it and send that to you. You can email it to support at agiletrack dot net.
—Posted by Adam Lane on Apr 4, 2007 at 7:23:35 AM
After looking into this more, a problem has been discovered in the automatic schema update for the AgileTrack HSQLDB driver. A fix will be included in the next release.
A database exporter/importer will also be included with the next server release which will allow a user to move between supported database engines.
—Posted by Adam Lane on Apr 8, 2007 at 9:36:20 PM
