Titles resume and already watched information

[NIIcK 10]

Hello,

I have recently moved my Emby Server installation from a Windows 11 machine to a Linux box. As far as I understood, copying everything as on a normal migration is not advisable when changing the OS from Windows to Linux as such I did a new install and re-created all my metadata however I was not able to find any info about where the titles resume (and already watched) info is stored (I am secretly hoping it is stored in a file somewhere on a per user basis and not in the DB) and I was wondering if someone in here would know about it? I know that the system folder is in /opt/emby-server/ and the users and metadata are, by default, stored in /var/lib/emby/.

Thank you in advance for your help!

Edited 1 hour ago by NIIcK
Expanding the post title a bit to be more descriptive

[GrimReaper 4918]

54 minutes ago, NIIcK said:

(I am secretly hoping it is stored in a file somewhere on a per user basis and not in the DB) 

Would you like a more emphatic way of saying it as "Hope is just a disappointment with a delay" or just plainly saying it as "Unfortunately, it's db-stored only"? 

Edited 51 minutes ago by GrimReaper

[NIIcK 10]

Thanks so much for your reply, @GrimReaper

In the myriad things of the world, the most real one is: database

All the best!

Edited 40 minutes ago by NIIcK

[GrimReaper 4918]

Were you using Backup & Restore plugin previously? Do you still have access to your old installation? 

[NIIcK 10]

Yes and yes. I have both backups and all Emby folders from Windows as a 7z archive.

[GrimReaper 4918]

Not sure how that would work on an OS migration and a new server, but in theory it just might as it's only manipulating db userids and item externalids: you can try Extracting user data from the Backup & Restore plugin UI (you'd map one previous user to a user on a new server instance). 

Edited 13 minutes ago by GrimReaper

[NIIcK 10]

It restored my interface and subtitles language settings but not the resume/watched data. It may be because it is a new install ...

[GrimReaper 4918]

4 minutes ago, NIIcK said:

It restored my interface and subtitles language settings but not the resume/watched data. It may be because it is a new install ...

Hm, I honestly don't know as I've never used it under that scenario - but I don't see why it wouldn't, as watchstates/playstates are tracked by item extetnalids which, in theory, should be the same on the new server just as they were on the old one, so that shouldn't matter. Maybe @Lukecan share some insight.