Merging Two Servers?

Plex Media Server Desktops & Laptops
,
1

Hello everyone,

Currently, I have two Plex Media Servers set up in separate locations. One of them is the “main” server, which contains most of the media, but it is at my mom’s house, where I no longer live. The second one. here in my apartment, is basically a Live TV/DVR server, and the only media it contains is from the recordings that I make using the DVR. I want to merge the main. remotely located server into my Live TV/DVR server. Everything located on the hard drives at the main server is mirrored on a hard drive here, so I know I could just recreate the libraries on the server here easily enough, but would lose all of my “watched” statuses and any custom metadata I’ve done (which I don’t think is much).

What I’m interested in finding out is, can I somehow merge the two databases? Both servers are running Windows 10. None of the libraries have the same names. However, what I think is going to make this difficult (if its doable at all), all of the media from the main server would not have the same physical location (it’s four separate drives at the main server, but it is backed up across two drives on the server that I want to “take over” as primary) than it has presently in that database. Is it possible to extract JUST that watched data/library data for the main server libraries, and merge it into the database of the Live TV server? I’m fairly tech savvy, but I don’t want to invest a ton of time in the project either… if it’s going to take more than 2-3 hours, I’m fine with losing my watched data, I’m just curious to know if it can be done.

Thanks in advance,
Josh

2

What you are describing is by no means a simple process. There is no automated way to do it. Your metadata modifications would be difficult to migrate over. You could at least get some semblance of those modifications through the query select * from metadata_items where user_fields like '%lockedFields%';. This will locate the metadata that has locked fields.

The view state can be copied over by copying the metadata_item_settings table. These rows use are by guid which here indicates the IMDB/TVDB ids for the metadata so they are fairly portable. You may have to filter on/update the account_id.

Hope that gives you an idea as to what you are in for. Sorry but I don’t know of a better way to merge the data.

1 Like
3

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