[mythtv-users] deleting music database
tgutwin at webarts.bc.ca
Sat Mar 24 22:27:31 UTC 2007
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 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
> I think you need to truncate the following tables to start afresh
> 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.
> mythtv-users mailing list
> mythtv-users at mythtv.org
--------------------- 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
More information about the mythtv-users