The Subsonic project recently added support for databases other than the built in HSQL database that has always been packaged with the Subsonic server. My Subsonic server manages about 40,000 media files and has ~40 users with hundreds of favourites and ratings. It was starting to perform slowly and index scans in particular were taking ~3 hours, so I was looking forward to moving away from the outdated HSQLDB system to MySQL.
Unfortunately, at this time there is no built in tool for migrating a Subsonic server’s data, which would have meant losing hundreds of favorited songs, user preferences, and passwords. To remedy this, I created the Subsonic Database Migration Tool. Theoretically it should be able to migrate a Subsonic database from any JDBC connection to another one, but I have only tested it with JDBC and MySQL.
Full instructions are on my GitHub page, but the short version is thus:
NEW_DB_URIand the two passwords.
OLD_DB_URIshould point to your existing HSQLDB database (/var/subsonic/db/subsonic on Linux).