[mythtv-users] How do I completely reset mythmusic database structure?

[Greg Grotsky]

On Tue, Apr 15, 2008 at 6:46 AM, Nick Morrott <knowledgejunkie at gmail.com>
wrote:

> Greg,
>
> Apologies, I was asleep at the wheel. The first update will obviously
> fail.
>
> Try:
>
> mysql> UPDATE `settings` SET `data` = '' WHERE `value` =
> 'MusicDBSchemaVer';
> mysql> DROP TABLE IF EXISTS musicmetadata;
> mysql> DROP TABLE IF EXISTS musicplaylist;
> mysql> DROP TABLE IF EXISTS music_albumart;
> mysql> DROP TABLE IF EXISTS music_albums;
> mysql> DROP TABLE IF EXISTS music_artists;
> mysql> DROP TABLE IF EXISTS music_directories;
> mysql> DROP TABLE IF EXISTS music_genres;
> mysql> DROP TABLE IF EXISTS music_playlists;
> mysql> DROP TABLE IF EXISTS music_smartplaylists;
> mysql> DROP TABLE IF EXISTS music_smartplaylist_categories;
> mysql> DROP TABLE IF EXISTS music_smartplaylist_items;
> mysql> DROP TABLE IF EXISTS music_songs;
> mysql> DROP TABLE IF EXISTS music_stats;
> mysql> DROP TABLE IF EXISTS smartplaylistcategory;
> mysql> DROP TABLE IF EXISTS smartplaylist;
> mysql> DROP TABLE IF EXISTS smartplaylistitem;
>
> Then re-run mythfrontend and post the results.
>
> --
> Nick Morrott
>

YAY.  That got me rollin'.  Thanks Nick.

-Greg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080415/10867ea4/attachment.htm