I recently had a problem with my server being improperly shut down, the database was somehow deleted. I've found that I still have a defaultdb.script file that appears to contain all the SQL commands to restore the last known good DB.
I've since switched to using Postgres and I'm wondering if there is some way to import that script in. If I have to import to HSQLDB, export and then import into Postgres, that's perfectly fine.