[mythtv-users] deleting music database
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:
> 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
> 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
> >> 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,
> >> 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
> mythtv-users mailing list
> mythtv-users at mythtv.org
Thanks, that did the trick.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users