Server Version#: Latest Plex Pass Version
Player Version#: N/A
Is there a way of migrating only my users’ watch status to a new PMS install? I want to basically setup a new Plex instance from scratch without bringing any of my current PMS database over other than my shared users’ watch status.
Possible?
There are ways involving database manipulation and backup but I have found that using Trakt works very well for watched status etc.
It is the easiest way I know to transfer watched status.
Sure, follow our guide. https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/
So I just tried this and I got the following return when trying to import the settings.sql file to the new database.
Error: near line 3: UNIQUE constraint failed: metadata_item_settings.id
Error: near line 8: UNIQUE constraint failed: metadata_item_settings.id
Error: near line 9: UNIQUE constraint failed: metadata_item_settings.id
Error: near line 10: UNIQUE constraint failed: metadata_item_settings.id
Error: near line 11: UNIQUE constraint failed: metadata_item_settings.id
Error: near line 12: UNIQUE constraint failed: metadata_item_settings.id
Error: near line 13: UNIQUE constraint failed: metadata_item_settings.id
Error: near line 14: UNIQUE constraint failed: metadata_item_settings.id
What does this mean and where does my new database stand now? Could this be because some of my users from database1 have been deleted over the years and are thus no longer on database2?
That means it is trying to insert tracking for a user and video that already exists in your file. Keep in mind that the article was designed for a clean setup, where the new server hasn’t had any status.
So it couldn’t add in the old information for a few things, but if that info already exists, then you didn’t need it anyways. You’re fine.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
