I’m upgrading to a bigger hard drive and will be moving over my library, but the new drive has a different name (which I’d like to keep).
Since I’ll be keeping the exact same structure and names for the movies and TV shows, what’s the easiest way make the move? Can I just edit the hard drive name in the Plex Library settings? Should I add the new directories, then remove the old ones?
On OS X, go there to find the SQLite3 database: ~/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db
NEVER, EVER, make any modification to your database before you backup the file (a duplicate, a second copy of it) in case things go wrong and you end up with a corrupted database…
Let’s proceed…
The desired database table is section_locations and the column os root_path.
Something roughly like this would do the trick:
UPDATE `section_locations`
SET `root_path`=
REPLACE(`root_path`,
'/Old_Volume_Name/',
'/NEW_Volume_Name/')
WHERE `root_path` like '%Old_Volume_Name%';
Make sure to correctly set every occurence (3) of Old/NEW_Volume_Name if you plan to use this example…