Trying to create a backup of my playlists and rating (and eventually move the ratings to something like IMDB), and I cannot figure out where they are stored. Are they stored server side by Plex?
If they are indeed stored in the database, where? I’d like to backup me and my family’s playlist.
Yes, playlist and your user ratings are stored in the database. If you want a backup, just backup the entire database.
There is no way to export this information so you can’t move them to IMDB.
If it’s in the database, it must be in a table, no? Plex doesn’t officially offer a way to backup watch history either, but through some other posts, I was able to back it up by finding it in the DB.
Do you mind expanding on why it can’t be exported/backed up? It might not be easy, and it might not even be in a ready format (linking to plex ids and what not), but if it’s data, there must be a way.
The playlist tracks each song by it’s ID in the database. If you create a new server, these ID’s will change. If you move your entire database to a new machine so those ID’s don’t change, the playlist info will already be there and go along with it. Trying to export the playlist can be done, but it’s basically unusable on it’s own without the rest of the database. I can explain where the data is but you’ll have to do some joins to make it usable, then you’ll have to so some more SQL magic on the target end to put it back. This last part is not so easy.
There is a 3rd party tool, I believe it’s called ExportTools, that will export/import this data for you. I would look to that instead of dealing with the database, unless you are really good with SQLite.
Is this the same for Movies/TV? or is this only difficult with songs?
PMS treats all playlists the same way. So, yes movies/tv too.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
