https://groups.google.com/g/ampache/c/-V6HS9ObyEs
UPDATE `song` SET `file` = (SELECT REPLACE(file, 'var/vhosts/ampache','var/vhosts/<new location>/ampache'));
UPDATE `catalog_local` SET `path` = (SELECT REPLACE(path, 'var/vhosts/ampache','var/vhosts/<new location>/ampache'));