[mythtv-users] delete music database/scan for music

[Neil Cooper]

I had a very similar issue and symptoms after just renaming and reorganising some of the mp3 files in my music collection.

The scan successfully added the new music files to mythmusic, but it didn't delete the old references even though no corresponding MP3 files existed on the filesystem any more.
 
After much messing about the only solution I found was to locate and truncate the appropriate database table then do another scan. This fixed the problem just fine.(can't remember the table name itself but it was very obvious... probably "music").

It seems odd that the scan doesn't empty the database table first. It seems a crazy presumption to make that users will only ever extend their existing library.


--- On Tue, 12/28/10, Craig Cook <cncook001 at yahoo.com> wrote:

> From: Craig Cook <cncook001 at yahoo.com>
> Subject: [mythtv-users] delete music database/scan for music
> To: mythtv-users at mythtv.org
> Date: Tuesday, December 28, 2010, 7:34 PM
> 
> 
> I seemed to have messed up my music database by moving my
> music directory 
> around.  I followed the "Importing an existing music
> collection" on the wiki, 
> set my music dir and did a scan.  I was hoping it
> would clean up all entries but 
> it did not.
> 
> I have seen other posts saying you need to truncate the
> music tables.  Is that 
> still the best method?
> 
> mythfrontend version: fixes/0.24 [8155c43]
> 
> I tried changing my music dir to /tmp, doing a scan, but
> the existing music 
> entries remained.
> 
> (I am happy to truncate the tables, just thought I would
> ask for other options 
> first)
> 
> Thanks
> 
> Craig
> 
> 
> 
>       
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>