[mythtv-users] deleting music database

matt lutz myth.matt.lutz at gmail.com
Mon Mar 26 14:29:47 UTC 2007


On 3/24/07, Tom Gutwin <tgutwin at webarts.bc.ca> wrote:
>
> I had the same problem.
>
> I fixed it by deleting all the entries from the following table:
> music_albums
>
> Delete From music_artists
> Delete From music_genres
> Delete From music_songs
>
> I did not have any playlists setup so I got away with only those tables
>
> It worked perfectly. The next time I went to MythMusic it rescanned my
> files with the new
> names.
>
> tom
>
> David Campbell wrote:
> > matt lutz wrote:
> >>
> >> Hey all,
> >>
> >> I'm having a bit of a problem with the music database.  I use iTunes to
> >> handle my music collection, and I recently had to re-install.  When
> that
> >> happened, a new version of iTunes changed some of the filenames around.
> >> In order to update myth, I ran a "scan for new music", and it ended up
> >> showing a bunch of duplicates in there.  I wanted to just start over,
> so
> >> I changed my music path to /tmp and then re-scanned.  What's strange is
> >> that it won't remove all of the entries... there were still a bunch in
> >> there (but many were deleted).  Then, if I restore to the correct path
> &
> >> rescan, there are even more duplicates.
> >>
> >> How do I just start over?  Can I just delete a table in the mythconverg
> >> database?  Any help is greatly appreciated.
> >
> > Deleting the table would be a bad thing if you wanted to use mythmusic
> > again.
> >
> > I think you need to truncate the following tables to start afresh
> >
> >   music_albums
> >   music_artists
> >   music_genres
> >   music_playlists
> >   music_smartplaylist_categories
> >   music_smartplaylist_items
> >   music_smartplaylists
> >   music_songs
> >   music_stats
> >   musicmetadata
> >   musicplaylist
> >
> > syntax is
> >
> > DELETE FROM TABLENAME
> >
> > to delete all the data but retain the table structure
> >
> > TRUNCATE TABLE TABLENAME
> >
> > would also work.
> >
> > You might want to wait for someone a bit more knowledgable about the
> > mythmusic before doing this  - your call.
> >
> > Dave
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
>
> --
> ---------------------     WebARTS Design      ---------------------
> Tom Gutwin                                          +1-604-626-9242
> tgutwin at webarts.bc.ca                      http://www.webarts.bc.ca
> GPG/pgp Pub Key: http://www.webarts.bc.ca/docs/tbgGPGPubKey.gpg.asc
> ---------     Engineering Your Computer Solutions...      ---------
>
>                Try our Free Ogg Vorbis Player
>                http://jOggPlayer.webarts.bc.ca
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>


Thanks, that did the trick.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070326/37d0740b/attachment.htm 


More information about the mythtv-users mailing list