How To Clean Up Your Database
Posted: Wed May 27, 2015 2:12 am[Posting here from previously posted external sites which may or may not continue to exist]
****WARNING: THE FOLLOWING INSTRUCTIONAL CAN AND WILL PERMANENTLY DELETE KEY ELEMENTS OF YOUR SUBSONIC DATABASE, INCLUDING BUT NOT LIMITED TO YOUR TRANSCODINGS, YOUR PLAYLISTS, YOUR SHARED FILES, YOUR STARRED FILES, ETC. PROCEED WITH EXTREME CAUTION AND WHEN IN DOUBT, TEST THE RESULTS FIRST ON A MIRRORED INSTANCE OF YOUR "MAIN" SUBSONIC SERVER TO MITIGATE THE RISKS INVOLVED; THESE ARE RAW DATABASE COMMANDS AND THEIR ACTIONS ARE TERMINAL - YOU HAVE BEEN WARNED!*****
From time to time you’re likely to run into issues with the internal database that Subsonic uses to store metadata and configuration. This article contains a couple of quick tips that should help fix issues with files in your media folders not being indexed correctly. Consider this like a forced re-indexing of the entire database.
Go to your Subsonic instance’s database configuration page — http://yoursubsonicinstall/db.view. Once there, paste the following into the text box:
Click the Submit button and wait patiently. When this operation is complete, go back to the index page of your Subsonic instance, click Settings, Media Folders, then Clean-up database. Once complete, re-scan the library; all of your issues should now be solved without losing your user settings.
Ostensibly, one could also use segments of the above, not necessarily every line, to clean out just one element.
****WARNING: THE FOLLOWING INSTRUCTIONAL CAN AND WILL PERMANENTLY DELETE KEY ELEMENTS OF YOUR SUBSONIC DATABASE, INCLUDING BUT NOT LIMITED TO YOUR TRANSCODINGS, YOUR PLAYLISTS, YOUR SHARED FILES, YOUR STARRED FILES, ETC. PROCEED WITH EXTREME CAUTION AND WHEN IN DOUBT, TEST THE RESULTS FIRST ON A MIRRORED INSTANCE OF YOUR "MAIN" SUBSONIC SERVER TO MITIGATE THE RISKS INVOLVED; THESE ARE RAW DATABASE COMMANDS AND THEIR ACTIONS ARE TERMINAL - YOU HAVE BEEN WARNED!*****
From time to time you’re likely to run into issues with the internal database that Subsonic uses to store metadata and configuration. This article contains a couple of quick tips that should help fix issues with files in your media folders not being indexed correctly. Consider this like a forced re-indexing of the entire database.
Go to your Subsonic instance’s database configuration page — http://yoursubsonicinstall/db.view. Once there, paste the following into the text box:
- Code: Select all
DELETE FROM ALBUM;
DELETE FROM ARTIST;
DELETE FROM BOOKMARK;
DELETE FROM MEDIA_FILE;
DELETE FROM MUSIC_FILE_INFO;
DELETE FROM PLAYER;
DELETE FROM PLAYER_TRANSCODING;
DELETE FROM PLAYER_TRANSCODING2;
DELETE FROM PLAYLIST;
DELETE FROM PLAYLIST_FILE;
DELETE FROM PLAYLIST_USER;
DELETE FROM SHARE;
DELETE FROM SHARE_FILE;
DELETE FROM STARRED_ARTIST;
DELETE FROM STARRED_ALBUM;
DELETE FROM STARRED_MEDIA_FILE;
DELETE FROM TRANSCODING;
DELETE FROM TRANSCODING2;
DELETE FROM USER_RATING;
Click the Submit button and wait patiently. When this operation is complete, go back to the index page of your Subsonic instance, click Settings, Media Folders, then Clean-up database. Once complete, re-scan the library; all of your issues should now be solved without losing your user settings.
Ostensibly, one could also use segments of the above, not necessarily every line, to clean out just one element.