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).
Have look at this post (and the thread in general):
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.
