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

[Greg Grotsky]

So I upgraded to SVN 16946 a couple weeks ago and ever since my frontend has
been complaining about:

2008-04-13 21:45:18.339 Upgrading to MythMusic schema version 1006
2008-04-13 21:45:18.340 DB Error (Performing database upgrade):
Query was: CREATE TABLE music_albums (    album_id int(11) unsigned NOT NULL
auto_increment PRIMARY KEY,    artist_id int(11) unsigned NOT NULL default
'0',    album_name varchar(255) NOT NULL default '',    year smallint(6) NOT
NULL default '0',    compilation tinyint(1) unsigned NOT NULL default
'0',    INDEX idx_album_name(album_name));
Error was: Driver error was [2/1050]:
QMYSQL: Unable to execute query
Database error was:
Table 'music_albums' already exists

new version: 1006
2008-04-13 21:45:18.341 Couldn't upgrade database to new schema, exiting.
2008-04-13 21:45:18.341 Unable to initialize plugin 'mythmusic'.


I've gone into the database and tried to randomly remove the tables and
columns it complains about but I always end up getting into some endless
loop and eventually restoring the whole mythmusic database structure (which
is broken).  My mythmusic used to work but now it won't even come up!  How
do I drop all the mythmusic stuff so that it can rebuild itself and be happy
again?

-Greg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080413/113b6868/attachment.htm