First, you don’t want to use that zip file. You need to find the original. It should be in
~/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db
Make a backup in case you make a mistake. Then you need SQLite to be able to read the file. MacOS comes with SQLite pre-loaded but there is no UI so I wouldn’t suggest using it. For beginners, I would suggest installing FireFox then the SQLite plug-in. This allows you to view your data visually. Try this and browse around a bit. I’ll provide the steps for finding the correct entry a little later after I’ve confirmed the steps.
