Hi @techge,
Quite old question, but I have to move my collection recently. It seems OriNOVet missed some data and tables to edit (may be new in last strawberry versions).
So, using only SQL request , you can use :
UPDATE
table
SET
mycolumn = REPLACE(mycolumn,'oldpath_substring','newpath_substring')
WHERE
mycolumn like '%oldpath_substring%';
I hope this is a complete data update :
UPDATE songs SET url = REPLACE(url, 'oldpath_substring','newpath_substring') WHERE url like '%oldpath_substring%';
UPDATE songs SET art_automatic = REPLACE(art_automatic,'oldpath_substring','newpath_substring') WHERE art_automatic like '%oldpath_substring%';
UPDATE songs SET art_manual = REPLACE(art_manual, 'oldpath_substring','newpath_substring') WHERE art_manual like '%oldpath_substring%';
UPDATE songs SET cue_path = REPLACE(cue_path, 'oldpath_substring','newpath_substring') WHERE cue_path like '%oldpath_substring%';
UPDATE subdirectories SET path = REPLACE(path,'oldpath_substring','newpath_substring') WHERE path like '%oldpath_substring%' ;
UPDATE directories SET path = REPLACE(path,'oldpath_substring','newpath_substring') WHERE path like '%oldpath_substring%' ;
Edit :
Before editing the database, may be disable "auto update library at startup" and "monitor library modification" in paramaters menu.
visitor
