[Topic] Backup HSQL Database

Need info on how to backup the HSQL single user data base. Can I move the database to a shared drive? Suggestions are welcome.

—Posted by Peter Kloosterman on Jan 27, 2010
Forum
AgileTrack Client
Reply

There are a couple possibilities for doing a backup of the HSQL database.

It's pretty easy to copy the HSQL database files, so any backup software would be able to handle that. If it were running off a shared drive that was part of an automatic backup, that would probably work well. I haven't tried this myself, but if that database were moved, the AgileTrack client settings would need to be updated to point to the shared drive. It might work to specify a full path to the database in another location, but I'm not sure at the moment—e.g. m:/backup/agiletrack_db

The AgileTrack server also has a way to export the database as a collection of JSON records. It is used for migrating the database between HSQL, MySQL, etc., but a scheduled task could periodically export the database in that format for backup.

—Posted by Adam Lane on Jan 28, 2010 at 8:18:14 AM


You may post a reply to this topic, but you must be logged in. If you already have an account, you may login now. If you need to create an account, you may also register now.