NAS moved files to a new location. How to fix playlists?

[MikeLegit]

I updated to a modern volume on my NAS and unfortunately this breaks everything on subsonic playlists because of the volume path change. Anyone know how to edit the subsonic db and do a search for "/share/MD0_DATA/Music" and replace with /share/CACHEDEV1_DATA/Music? Or even better, just remove MD0_DATA as it is already linked by the NAS to /share/Music?

Thanks.

[MikeLegit]

Anyone have a step-by-step guide on how to do this with a database editor such as RazorSQL?

[Jägs]

There are two ways you could do it:

1. Export the playlists to M3U, edit them in your favorite text editor to replace the old paths with the new paths, and then re-import them into Subsonic.
2. Use the db.view page (http://(your server):(subsonic port)/(subsonic path)/db.view to do an update on the file paths.

The first is easiest and safest as it requires not DB work. The second isn't too bad, but you do risk borking your DB if you are not careful. The following is code I tested on my install, but *WARNING* I am no HyperSQL expert, so I make no guarantee that it will work on your end.

Code: Select all

update media_file set path = replace(path, 'oldpath', 'newpath') where id = X

So, this will replace that path of a specific file with an ID of X. You can omit "where id = X" to update all file paths, but BE CAREFUL!

[MikeLegit]

Thanks Jags! I like the option 1, however I have about 70 playlists and it would take forever to export import 1 by 1.

For option #2, my playlists are across many directories. Example:

NAME - FOLDER
80s - /share/Music/80s
Alternative - /share/Music/Alternative
Audio Books - /share/Music/Audio.Books
Classical - /share/Music/Classical
Classic Rock - /share/Music/Classic.Rock

Based off the HyperSQL code you posted, would it be something like this to replace globally?:

Code: Select all

update media_file set path = replace(path, '/share/MD0_DATA/Music', '/share/Music')

Or would that kill my lists give I am in different directories?

Mike

[Jägs]

Actually, for method 1, it's pretty simple to export playlists out of Subsonic en masse. Somewhere on the forum, someone posted a Java program to do that. I happen to prefer Perl, so wrote one that heavily borrowed from the Java program:

http://forum.subsonic.org/forum/viewtopic.php?f=5&t=17436

Once you get them in M3U, a text editor will make short work of fixing the paths. Then, you put them in a folder and under Settings --> General, there is an "Import playlist from" option. Point that to where your newly fixed M3Us are at, and on the next sync, Subsonic will import them with the new paths. This won't affect your existing Playlists, so you'll have duplicates, but this way, you can confirm that they are working before deleting the old ones.

For method 2, I may have misunderstood your original post. If you've moved and already scanned the new media paths into Subsonic, I'm not sure there is going to be a clean method to fix this with the DB, short of changing the paths per the update code, but you'll end up with duplicates. That said, I think method 1 is your best bet.

The other benefit of method 1 is that it is a nice backup solution for your playlists. I've had to reinstall Subsonic from scratch a few times, and this saved me hours of manually rebuilding playlists.

[MikeLegit]

That is what I will do then. I really appreciate your help! I will also cron out a backup using this script. Very nice contribution Jags!

-ML