#plex must be stopped for database edits
docker stop plex
#create a copy of the plex database
cp /opt/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db /opt/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db-backup
#open the plex database with sqlite3 (Unsure if sqlite3 is installed by default, believe so)
sqlite3 /opt/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db

#Update all references of `/unionfs/plexdrive/Movies` with `/mnt/unionfs/Media/Movies`
UPDATE section_locations SET root_path= REPLACE(root_path, '/unionfs/plexdrive/Movies', '/mnt/unionfs/Media/Movies') WHERE root_path LIKE '%/unionfs/plexdrive/Movies%';
UPDATE media_parts SET file= REPLACE(file, '/unionfs/plexdrive/Movies', '/mnt/unionfs/Media/Movies') WHERE file LIKE '%/unionfs/plexdrive/Movies%';

#Update all references of `/unionfs/plexdrive/Series` with `/mnt/unionfs/Media/TV`
UPDATE section_locations SET root_path= REPLACE(root_path, '/unionfs/plexdrive/Series', '/mnt/unionfs/Media/TV') WHERE root_path LIKE '%/unionfs/plexdrive/Series%';
UPDATE media_parts SET file= REPLACE(file, '/unionfs/plexdrive/Series', '/mnt/unionfs/Media/TV') WHERE file LIKE '%/unionfs/plexdrive/Series%';

#ctrl + d to quit from sqlite3

docker start plex