How view the Music Play List in the database?

Plex Media Server NAS & Devices
1

I hope this has a simple answer…

I recently decided to upgrade the Metadata (and file names) for my music using MusicBrianz Picard. …with that said, I emptied the trash and my music playlist lost 80% of the songs. I know why it happened, I just wished I didn’t empty the trash so soon. The songs would not play, but they would still be in the list and I could have used the list as a reference point.

So I had an idea, if I could see the list I could manually search for each song and recreate the a new playlist. I found this article and I seem to be on the correct path.

So here is where I need help.
I’m using an old backup of the database file (copied to a temp directory), using the SQL Lite Browser. I’m hoping to see a “readable” playlist, that I can use as a reference point.
Where is the playlist located in the DB?

Or is there another way?

2
  • Install ExportTools
  • Disable remote access
  • Shut down PMS
  • Make backup of current database
  • Copy in backup database
  • Start PMS
  • Use ExportTools to generate the needed list
  • Shut down PMS
  • Bring backed-up’ed database of the current one
  • Start PMS
  • Enable Remote Access again
  • Digest output from ExportTools
3

Perfect!

This worked. For those who find this post, a few things to note.

  1. I’m using Unraid and PMS Docker - I had to adjust the permission to install the plug-in

  2. Make sure you set up the file export path in the plug-in and uncheck the box for ignore the export path…

otherwise, this was a very easy process - Thanks dane22

2 Likes
4

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