Export DB files patches to txt/csv after HDD malfunction

Plex Media Server
1

Hello, one of my HDD just broke down… and I need to re-create content on another HDD. How to access what files was on this drive (in my case is A:\). Tried ChatGPT to create bat file or another script to filter out what files was on broken drive but this is not working. Now trying SQL DB browsers to find that data, but still i cant find and make list what files was on broken drive. Any tips how to do this simply?

Im working on com.plexapp.plugins.library.db file located at C:\Users\MyUser\AppData\Local\Plex Media Server\Plug-in Support\Databases\

2

Try this: https://github.com/WebTools-NG/WebTools-NG/wiki/ExportTools

3

Im using now similar DB Browser but still I cant find files pathes… I found all tags, descriptions etc but no pathes of files

Zrzut ekranu 2026-03-04 194054
Zrzut ekranu 2026-03-04 1940542554×1170 265 KB

4

With WebTools, use a custom level and include title and Part File Path

See: https://github.com/WebTools-NG/WebTools-NG/wiki/Help-(Hints%2C-Tips-and-Videos)#create-a-custom-level-and-export-art--posters-from-a-movies-library

5

Thanks, I have almost 10K items to process and waiting for output… dont know why so slow. I have Ryzen9-7900, RTX4060, 32GG DDR5 and after 10m its done 1K of 10K items.

6

Might be either a more or less broken database, since I assume you only added the two fields to the custom level as I suggested?

Another option could also be: https://github.com/WebTools-NG/WebTools-NG/wiki/Find-Media

7

Thanks a lot, it works. Yes I set only Title and Part File Path, now I have a list of 1K items to re-create… :joy:

Only thing is that csv output have wrong coding and some non-english titles (in my case with Polish signs) are hard to read but I only need to verify WebTools-NG settings

8

Just FYI if you are still curious.

To get just the file path you can run this query:

SELECT mp.file
FROM media_parts mp;

If you also want the title, this query will get it:

SELECT child.title, mp.file
FROM media_parts mp INNER JOIN media_items mi
	ON mp.media_item_id = mi.id INNER JOIN metadata_items child
	ON mi.metadata_item_id = child.id;

Some extra queries since TV series have entries for the series name and the season.
This query will provide the season (any entry without that data will just be null, so movies for instance):

SELECT parent.title AS "parent_title", child.title, mp.file
FROM media_parts mp INNER JOIN media_items mi
	ON mp.media_item_id = mi.id INNER JOIN metadata_items child
	ON mi.metadata_item_id = child.id LEFT JOIN metadata_items parent
	ON child.parent_id = parent.id;

This query will provide the series name along with the season (and same caveat from above for entries that do not have that data):

SELECT grandparent.title AS "grandparent_title", parent.title AS "parent_title", child.title, mp.file
FROM media_parts mp INNER JOIN media_items mi
	ON mp.media_item_id = mi.id INNER JOIN metadata_items child
	ON mi.metadata_item_id = child.id LEFT JOIN metadata_items parent
	ON child.parent_id = parent.id LEFT JOIN metadata_items grandparent
	ON parent.parent_id = grandparent.id;

-Shark2k

9

Should be what PMS has, and also should be in UTF-8