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 2 hours ago by NIIcK
Expanding the post title a bit to be more descriptive

[GrimReaper 4919]

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 1 hour 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 1 hour ago by NIIcK

[GrimReaper 4919]

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 4919]

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 1 hour 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 4919]

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. 

[CBers 7559]

Watched data is held in the user.db I believe, and you can restore it via the Legacy Backup & Restore plugin.
 

[GrimReaper 4919]

9 minutes ago, CBers said:

Watched data is held in the user.db I believe

Nope, it is actually held in the userdata table in the library.db. Users.db contains information about user accounts, settings and credentials.

[NIIcK 10]

Thank you @CBers, for some reason it does not restore the resume/viewed info. I only have what I have started viewing on the new server, after the move.

[CBers 7559]

1 minute ago, NIIcK said:

Thank you @CBers, for some reason it does not restore the resume/viewed info. I only have what I have started viewing on the new server, after the move.

Have you copied across the backup from your Windows server?
 

[NIIcK 10]

What kind of the DB editor can be used to manipulate the DB? Maybe I can export the specific entries and insert into the new DB?

[NIIcK 10]

8 minutes ago, CBers said:

Have you copied across the backup from your Windows server?
 

Yes. I have a group that has write rights on the backup folder and the Emby user set up as a member.

[GrimReaper 4919]

6 minutes ago, NIIcK said:

What kind of the DB editor can be used to manipulate the DB? Maybe I can export the specific entries and insert into the new DB?

Roaming around the db is never advisable, so proceed at your own risk. 

That said, you can use any editor of your preference, like this one. Just ensure the users have the same db id per server as the users.db assigns them db ids.

[CBers 7559]

22 minutes ago, NIIcK said:

Yes. I have a group that has write rights on the backup folder and the Emby user set up as a member.

And you are using the Legacy Backup & Restore plugin to restore the user data?



Perhaps because of OS changes, it's not compatible, I'm not sure.