Plex¶

Modifying Database¶

Bulk File Path Changes¶

Deployed an alpine container and exec'ed inside:

apk add --no-cache sqlite
sqlite3 "/mnt/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db"

SQL Commands¶

SELECT id, file FROM media_parts WHERE file LIKE '%/data/series%';
UPDATE media_parts SET file = REPLACE(file, '/data/series', '/mnt/media/series');
SELECT id, file FROM media_parts WHERE file LIKE '%/data/movies%';
UPDATE media_parts SET file = REPLACE(file, '/data/movies', '/mnt/media/movies');