Sync watch data between two users

General Discussions
1

I have some users on my server that I originally set up as managed users. Now knowing the difference between user types more clearly, I realize I should have set them up as their own users in my home.

I want to create new users for them and move their previous watch data to those new independent accounts.

The best way I can find to do this is the Trakt-sync plugin, but it doesn’t seem like it will sync everything and I have seen mixed reviews (including privacy concerns).

Is there a way to do this working in plex or in the terminal?

Thanks!

2

Be sure to download a backup of your Plex database beforehand!

Then you can try https://www.reddit.com/r/PleX/comments/8ni1sr/how_to_manually_copy_watched_from_one_user_to/

3

Thanks! Hours of googling and somehow didn’t find that thread.

Do you know if anything has changed in past 3 years that would modify the steps in that reddit post?

4

Sorry, no. Maybe @anon18523487 knows.

5

I’m not familiar with that thread or those instructions specifically. However, if you are switching users, then an easier approach is to edit the current data to use their new ID.

First create the new user.

If you look in the “accounts” table, you should see the ID’s for the previous managed user and the new one.

Then you want to edit the “metadata_item_settings” table and replace the Account ID from the old to the new. Replace the words below with the actual id number. Repeat for each user.

update metadata_item_settings set account_id = NewID where account_id = OldID;

1 Like
6

Where is the accounts table? Looking through the metadata folder, I don’t see anything that says accounts table.

7

It’s in the Plex database. Use this article as a reference for where to find it. Repair a Corrupt Database | Plex Support

8

Gotcha thanks!

So basically, I just need to backup the file, copy the original to my Windows machine and modify it with something like DB Browser for SQLite.

Find both the old ID and new ID for each user and run that command for each user?

9

Precisely.

10

Just did it with one of the 3 users, worked perfectly. Thanks!

1 Like
11

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.