Question about copying watched status

Plex Media Server
1

I’m currently in the process of rebuilding my database, and would like to retain the watched status for all my users, if possible. I’ve followed the instructions found here Move Viewstate/Ratings from One Install to Another | Plex Support and I have the settings.sql file.

I started from scratch, and I’m currently scanning all my libraries anew. Once the libraries are finished rebuilding, I was planning on copying the settings.sql back into the database. But I was thinking about it, and I was wondering if this would work. Since the database has been rebuilt from scratch, the records for individual episodes and movies won’t be the same as the old database. So will this process work?

2

Only if you are using the same metadata agent for the library. The status is based on the GUID for the item, not the itemID. If your movie library was using TheMovieDB for example a particular movie might have GUID tmdb12345 that same movie matched with Plex Movie (legacy) might have GUID tt54321

So if your database has a viewstate record for movie tmdb12345 at 76% complete for UserX. The movie needs to be matched with the same agent to get same tmdb12345 ID that matches the viewstate record

hope that makes sense

2 Likes
3

Got it, thanks. Yes, I am using the same agent on both servers (the new tv agent and the new movie agent). So it sounds like I should be good to go.

4

I wondered why play status and up next only worked part of the time when replacing a library with a new “copy”. When it didn’t work correctly I know for sure I switched agents lol

Thanks for the clarification!

5

I have another question about this, since I’m still waiting for the database to finish updating. If something is watched on the new server during the interim (in other words after I exported the settings.sql file) but before I re-import it back in, will that watched status be retained? Or does that get wiped out when I copy the watched status back into the database?

6

When you import the viewstate records from the other server, the data is added. Existing records on the new server aren’t replaced.

7

Thanks for the help with this, I have been able to successfully transfer the view states to the new server, and it has worked perfectly!

One other question, is there a way to do the same with playlists? Since the new server has started rebuilding, I noticed that playlists have been lost. I still have the old database, is there a way for me to extract the playlist information from the old database, and apply it to the new one?

8

There is not a way to do that I am aware of but possibly @dane22 's webtools or exporttools might be able to

1 Like
9

Click below:

10

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