Recover HSQLDB file/directory structure
Posted: Mon Dec 18, 2017 10:45 pmMy hard drives crashed but I was able to recover most of the data, albeit very unstructured.
I have backups of my subsonic database (binary file) and was hoping I could use it to get a listing of my directories/files (either by filename or hash). I could then write a quick script to map the files to their proper locations.
But I'm on a mac and I'm having trouble getting SQL access to the subsonic database to inspect the schema and write a query. I can access the SQL interface via the web UI but it crashes on any substantial query (file is > 200 MB, a few TB of tracks).
If I could convert the hsqldb file to a postgres database my life would be a heck of a lot easier. Anyone have any ideas?
I have backups of my subsonic database (binary file) and was hoping I could use it to get a listing of my directories/files (either by filename or hash). I could then write a quick script to map the files to their proper locations.
But I'm on a mac and I'm having trouble getting SQL access to the subsonic database to inspect the schema and write a query. I can access the SQL interface via the web UI but it crashes on any substantial query (file is > 200 MB, a few TB of tracks).
If I could convert the hsqldb file to a postgres database my life would be a heck of a lot easier. Anyone have any ideas?