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

General Discussions Tips, Tricks & How-Tos
43

Yeah, that was the issue…it’s working now. Cheers!

Script:

insert into section_locations 
select (select seq from sqlite_sequence where name = 'section_locations') as id, library_section_id, 'G:\Movies' as root_path, available, scanned_at, created_at, updated_at 
from section_locations 
where root_path = 'F:\Movies';

update sqlite_sequence 
set seq = seq + 1 
where name = 'section_locations';

UPDATE metadata_items
SET guid= replace(guid, 'F:\Movies\', 'G:\Movies\')
where guid like 'F:\Movies\%.mp4';

UPDATE media_parts
SET file= replace(file, 'F:\Movies\', 'G:\Movies\')
where file like 'F:\Movies\%.mp4';

UPDATE media_streams
SET url= replace(url, 'F:\Movies\', 'G:\Movies\')
where media_item_id in (select media_item_id from media_parts where file like 'G:\Movies\%.mp4');

update media_items 
set section_location_id = (select id from section_locations where root_path = 'G:\Movies') 
where id in (select media_item_id from media_parts where file like 'G:\Movies\%.mp4');
3 Likes