How to migrate openfire from embedded to external

Solution 1:

This is kind of a lame way to do it, but if you're having problems finding the file when it's offline (which I can't explain):

You can take a backup of a live hsqldb as long as a checkpoint has not occurred during the backup. A checkpoint will occur every time the log file fills up. There is a setting in the embedded-db's properties file:

hsqldb.log_size=50

(which is in meg - 50M)

As long as the log file doesn't hit that size during the file copy of the live db file, the file will be consistent. Whatever is in the log file has not yet been written to the db. If you can do this during off-hours, you can get a reasonably good dump file.

So.. you could kill any active sessions, do the file copy, shutdown the server, and then proceed from there.