Restore Watched Status

[enesha]

Good Morning all

    So I'm back again with another problem.  After other issues I was trying to turn my JF into a VM on my network.  I do not use Docker, so this is a full (minimal) Bookworm install.  Ok so great that will make my backing thing up easier.  Ok so theres a catch

Per a previous suggestion from TheDreadPirate I was trying to restore the config directories.  I removed all the libraries from JF and was trying to rescan the full library in a (Unraid) consolidated drive mounted via virtiofs.  This was marginally successful.  The server was being pissy, and was adding libraries multi times (tv, tv1, etc) and the server complained heavily in the logs re: missing jpg's etc for the various screens.  Whatever.  I finally got it to start working and watched some shows while it was rebuilding.  Success! (or I thought).

Next day I can't connect.  Log file said that the jellyfin.db file was damaged.  Did a search and found a bug report in JF regarding this just happening to people.  There was included a bit of sql to dump the sql, change the last line a bit, and import into new db.  No go.

Ok so I stole the jellyfin.db from the old physical machine install..and after much fighting I ended up with a fresh install from the .deb and then put the old jellyfin.db into the dir, and voila I am able to log in.  It seems to have the users and perhaps their log in info (the db was about 30 megs).  This works for basic stuff, my ask is about viewing data.

I can log in.  I can watch shows, etc  However the shows all look as if I have never watched them.  I would like to restore the viewed status.  What shows/movies I have watched, and what season/episode is next for me.

I still have the physical drive..Is there some way to import JUST the viewing data, at this point?  I just don't want to have to go in and tag everything i've already watched just to get back to status quo

Thanks!

[enesha]

BTW to add to the discussion....This is the problem that hit me, out of nowhere:

https://github.com/jellyfin/jellyfin/issues/12701

[TheDreadPirate]

library.db contains all your watched status. You would need to restore that. But that contains all the metadata paths and library info, etc. AFAIK, you cannot easily import JUST the watched status since that info is tied to database entry for that piece of content, and that database entry is tied to a file path.