Updating media path in Plex database

[Martin.Bolding]

Following a hardware failure of my old NAS I have recovered my data (both media files and Plex configuration) from a Netgear ReadyNAS to a QNAP system.

However, the highest level folder (corresponding to the RAID volume name or storage pool) over which I have no control, has changed, so (as an example) a file which was at:

/VOLUME00/Music/CD/ABBA/Number Ones/01 SOS.flac
is now at:
/share/Music/CD/ABBA/Number Ones/01 SOS.flac

While I have created a symbolic link to map /VOLUME00 to /share (which works!), ideally I’d like to correct the paths held within the Plex (SQLite) database. If the database were a plain text file I could just do a global find/replace of “VOLUME00” with “share”, but clearly it’s a bit more complex than that. Can anyone help with a set of commands to execute within the Plex SQLite shell to achieve this (or point me in the right direction at least).

Many thanks.

[pshanew]

Have look at this post (and the thread in general):

[HowTo] Plex database modification - Moving media the right/wrong way

Ok, wow! That was surprisingly easy. Everything seems to be working GREAT! So just so it’s clear. Following my instructions will likely mess up your Library. But it worked wonders for me. AND it is SO easy. Easier than following the nuanced instructions in that article I linked above. Shutdown plex server Backup your data Backing Up Plex Media Server Data | Plex Support Copy your content to the new location Drop the triggers that prevent editing your database. Edit your database. Find the lo…

It describes the database modifications necessary to update the media locations if its path changes.

I hope it’s obvious, but back up your database before making any changes. Heck, back up the entire Plex Media Server data directory. And ensure that PMS is stopped while making any DB changes.