[mythtv-users] Re: Clearing MythMusic database/metadata

[Mike Geisterfer]

BP wrote:

 >Mike Geisterfer wrote:
 >
 >Second option is to dump the musicmetadata table from the database.
 >
 >With mythbackend stopped:
 >mysql -u mythtv -pmythtv mythconverg
 >
 >
 >>drop table musicmetadata;
 >>quit
 >>
 >>
Probably safer to delete the contents of the table.

DELETE FROM musicmetadata;

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
<http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users 


Thanx BP and Mike.....

That worked perfectly...

BP (i didn't find that post when I went looking, but thanx for the info)

Mike: Worked perfectly.... DELETE FROM musicmetadata
Database is clean now. MythMusic just rebuilt when I started it.

Again thanx...

Mike G. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20050605/e0f3e261/attachment.htm