Is it possible to export music playlists, watch status and sonic analysis from a DB and import it into a new one?

Server Version#: 1.26.2.5797
OS: Windows 10

So the new 1.27 update broke my music library and I’m facing a dilemma. I’m either going to have to:

  1. Keep my server downgraded to 1.26 which is the last version where my database works properly, or…
  2. Nuke my database and rebuild everything from scratch, and lose my watch statuses as well as my music playlists and sonic analysis data.

Both of these choices are not desirable at all. I have already tried downgrading back to 1.26, running a DB repair and attempting to install 1.27 afterwards but unfortunately that did not fix the issue.

I don’t want to stay on 1.26 because as time goes on it will become more and more outdated and I will miss out on all the latest features and optimizations. But at the same time, updating to 1.27+ means I am going to have to wipe all of my libraries and rebuild everything, which is a horrible outcome. So I’m hoping there’s some way to, at the very least, export the 3 most important parts of my old DB into the new one.

Is it possible to somehow export all these things from my old DB and import it into a new database? Or am I going to be forced to lose all of these?

bumping this, would REALLY like to know if this is possible since 1.27+ is off the table for me otherwise

Unfortunately not.

Have you tried the “manual” DB repair? If not, do it. Repair a Corrupted Database | Plex Support
(For added fun, perform the repair also for the blobs database file.)

Moving watch status is possible, but not easy. You would need to write a custom script using the API to record watched status based off filename. Then use that list of file names to mark watched on the new database.

I use something similar in my setup.

it seems this page has updated a lot over the past few days, it looks completely different than it did when i tried a repair.

i tried all the steps this time that were shown on the newly-updated page and it worked, whereas the old page did not help fix the issue.

thankfully this means i was able to update to 1.27 without issue this time, but i still think Plex should have an easy way of exporting this data out of a database in the event that one runs into an unrecoverable db and is forced to start over

interesting… do you mind sharing this script? or is it already available somewhere

See Tagging for Collections by Folder location - #12 by dbirch

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