need help recovering playlists after re-install

[rumremix]

Hello, I had to completely uninstall the reinstall subsonic in order to solve this problem: viewtopic.php?f=2&t=17513

Since playlists now live inside the subsonic data files, I lost all of my playlists (and starred songs and albums) that I have been accumulating for many years. Luckily, I backed up my data files from the old installation so should be able to recover those lists. However, my attempts at simply copying over the old data file to the new installation doesn't work.

Specifically, here's what I tried:
(1) I stopped the subsonic service
(2) I renamed subsonic.data in the subsonic\db\ directory to subsonicNew.data
(3) I copied subsonic.data from a backup of the old installation into subsonic\db\
(4) Restarted subsonic service
Result: web page returns a 503 error. Specifically, this

Code: Select all

HTTP ERROR: 503

SERVICE_UNAVAILABLE
RequestURI=/index.view

Powered by jetty://

Backing out of the above steps makes subsonic happy again but no playlists.

Does anyone have suggestions on a way to recover my playlists from the backed up data files?

i know one way, but I don't like it: I can stop subsonic, replace the new installation files with the backed-up old installation files, then restart. This will get me back to where I was before: unable to scan my media but at least I'd have access to my playlists, which I could export. Then I could revert to the new installation files, and import the playlists. This will work except for three problems: (1) I have a lot of playlists so it would take a really long time to export each, one at a time; and (2) although I can convert my starred songs into a playlist and export that playlist, upon importing that playlist into the new installation i'd end up with a playlist, nothing actually starred. And i have no idea how to re-star those songs other than one at a time (there are many thousands). (3) no idea how to recapture starred albums.

So i am hoping there is a better way to recover that playlist and starred data that does not involve piecemeal manual export/import via the web interface.

Thanks for any suggestions!

[rumremix]

Pretty quiet in here. Adding an additional post as doing so is the only way I know to set it to notify me of new replies. Hoping there are some suggestions out there.

[Exrace]

Wonder if the cleandb function in web interface would fix this issue?
I posted this in your other topic.

[rumremix]

That is a good suggestion, Exrace, and something I had not tried. I just tried it now. I reverted to the old files (containing playlists and starred data but resulting in scan errors) and clicked the "clean-up database" button in settings. Unfortunately, this also resulted in a org.springframework.dao.TransientDataAccessResourceException error. Was worth trying though and I appreciate the suggestion.

[Jägs]

Unfortunately, I cannot help with your immediate problem. Having been in a similar situation, though, I would suggest that if you do get things back up and running, you export and back up your playlists. There are a couple of automated scripts for doing this floating around the discussions, but here's one I wrote in Perl:

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

Best of luck!