Migrate Local and Remote User Watched Status - *nix to Windows

Plex Media Server Metadata & Adding Files
1

Server Version#: 1.19.4.2902
Player Version#: N/A

I’m attempting to move my watched status from an unRAID Docker (PMS Official) to a newly provisioned Windows VM living on ESXi. I have added all of my Libraries and allowed the new Plex instance to pull-down the metadata; everything is working as expected.

The one issue I’m running into is migrating all of the Local and Remote (Shared User) watched status to the new instance. I referenced this article: https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/

I’ve successfully dumped the necessary tables to the settings.sql file and I’m able to execute the command. However, the issue is the amount of columns doesn’t line up and results in the error below:

Error: near line 69331: table metadata_item_settings has 13 columns but 14 values were supplied

It’s also worth noting that I’ve been running Plex for 8+ years so this DB has gone thru a lot of updates :).

2

Bump - any feedback here?

3

What version of PMS were you running before? Those instructions assume it’s the same version of PMS involved. Due to updates in PMS, the database structure can change so if you aren’t using the same version, you may run into this issue.

If this is the case, update PMS on the old computer first so it will update the database, then rerun the export.

4

Thanks for the reply. It turns out I was using the wrong ****.db file. Apparently there are 2. One in the root dir and one further down the rabbit hole under Plugin-Ins support. I’m not sure why both are present but after using the correct one - all was well.

5

The one in the root directly is a blank that’s used as reference. If you delete the one you are using, PMS will copy over this blank one to start over.

6

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