Constructing tag hierarchy via import, API or other programmatic means?

I use tags in my large photo collection to form a complex virtual hierarchy I use across the various applications I use a to edit photos, as well as maintain the smaller amount of videos and music.

I need to keep this virtual structure consistent across several application and not just Mezzmo, so I am working towards maintaining one structure definition and importing it into the various applications. I have also had several occasions where I've needed to reset the Mezzmo database and again would like to be able to create the virtual hierarchy without spending hours in the GUI. For reference I reset the database due to duplicates, issues with incorrect auto artwork for music/videos and the approach of creating a Smart list to delete all file references while leaving the structure intact takes far too long even on SSD (and still doesn't solve the initial creation issue).

Before I start looking into reverse engineering the SQLite tables to see if that's one option, is there any existing means to import the media structure in Mezzmo? It would be great if I could create an XML/JSON or similar file and use that preset the structure.

Currently you can export the files in a playlist into an external playlist file from the file menu in Mezzmo. This creates a flat playlist file for the selected playlist and you need to do this manually for each playlist. It does not allow re-creating active or smart playlists. The best approach is to keep a backup of your Mezzmo database so that you can always recover from a database failure or reset and restore your previous playlists. Create a database backup in Options in Mezzmo.