I use Intro Skipper to automatically skip the intros/recaps in TV shows. But I have found that the automatic intro detection is not great and often misidentifies the media segments a bit. Because of that, for some TV shows, I have put a lot of time/effort into manually setting the media segments for each episode using the Segment Editor in the Jellyfin web UI.

But recently, for whatever reason, I seem to have lost that media segment data. Now, when I watch any of those episodes that I had definitely meticulously manually set the media segments on, it just has the original automatically-generated bad segments again instead.

I definitely have backups of this server. Can I just restore a certain folder from a backup in order to restore my media segments? Searching around the filesystem, I just cannot find where media segment data is stored. Furthermore, I am concerned that the filenames and everything may no longer match. As far as I understand, shows/episodes/etc. in the Jellyfin filesystem are actually assigned a random n-character unique identifier, and I worry that identifier for each item may not be exactly the same as it was in my backups for whatever reason.

you are viewing a single comment's thread
view the rest of the comments
[–] 1 point 3 months ago*

It is as you say, just sqlite3 via command line. I’m sure there are guis as well.

For deleting live tv channels for example I use:

sqlite3 /appdata/jellyfin/data/jellyfin.db "DELETE FROM BaseItems WHERE Type = 'MediaBrowser.Controller.LiveTv.LiveTvChannel';" sqlite3 /appdata/jellyfin/data/jellyfin.db “DELETE FROM BaseItems WHERE Type = 'MediaBrowser.Controller.LiveTv.LiveTvProgram';"

Of course make sure Jellyfin is not running as live editing the db will likely result in corruption.

It can also be wise to do an integrity check to make sure your edits didn’t wreck shit

sqlite3 /appdata/jellyfin/data/jellyfin.db “PRAGMA integrity_check;"

Alternatively you may be able to do this more safely via the swagger api but I just learned about this so im not sure: http://[jellyfin-ip]:8096/api-docs/swagger . Documentation here https://api.jellyfin.org/

  • source
  • parent