[mythtv-users] MythMusic: rebuild music database?

[Brad DerManouelian]

On Sep 24, 2007, at 12:29 PM, matthew.garman at gmail.com wrote:

> On Mon, Sep 24, 2007 at 08:45:33PM +0200, Herman Kuiper wrote:
>>> Is there a way to purge this cache information?
>>
>> Other than truncating all tables starting with music_ in the
>> database, no I don't think so. At least I couldn't find one when I
>> needed to do the same...
>
> So did you end up doing just that (truncating all the tables
> starting with music_)?
>
> Is the MythMusic table structure documented anywhere (other than
> implicitly in the code)?  I'd like to DELETE FROM as few as tables
> as possible, although I suppose it's not hard to make a backup of
> the database.
>
> Matt

Tables are here:
http://www.mythtv.org/wiki/index.php/Category:DB_Table

I believe SVN uses mp3act and therefore follows mp3act table structure.