How can you move items between Plex libraries without losing the metadata?

[mens_sana]

@mens_sana

If you ever worked with SQL, this is unfairly simple…

On OS X, the SQLite3 database file is:
~/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db

On Linux, the SQLite3 database file is:
$PLEX_HOME/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db

On Windows, the SQLite3 database file is:
"%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db"

HOWEVER, 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…

so here it is…

The coveted database table is section_locations and the column is root_path.

Something like this would do it:

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 occurences (3) of
Old/NEW_Volume_Name if you plan to use this example…

And simply to make it easier quicker, here is an open source tool to make these changes:

SQLite Browser
(this will do the trick) (OS X, Linux, Windows)