[mythtv-users] MythMusic database upgrade failure

[Robin Gilks]

I've just upgraded from 0.21-fixes to 0.22-fixes. I guess that over the
last 4 years I've accumulated some cruft because each time I start the
frontend I get the following:

2009-11-13 12:26:50.471 Current MythMusic Schema Version
(MusicDBSchemaVer): 1013
2009-11-13 12:26:50.472 Timed out waiting.
2009-11-13 12:26:50.491 Backing up database with script:
'/usr/local/share/mythtv/mythconverg_backup.pl'
2009-11-13 12:27:08.702 Database Backup complete.
2009-11-13 12:27:08.713 Backed up database to file:
'/mnt/store/mythconverg-1244-20091113122650.sql.gz'
2009-11-13 12:27:22.344 Upgrading to MythMusic schema version 1014
2009-11-13 12:27:22.345 DB Error (Performing database upgrade):
Query was: DROP TABLE musicmetadata;
Error was: Driver error was [2/1051]:
QMYSQL3: Unable to execute statement
Database error was:
Unknown table 'musicmetadata'

new version: 1014

After this, I'm still unable to enter MythMusic

I'm quite happy to drop the music database tables to start from scratch,
if someone could tell me how to do that, as all my files have tags so
re-scanning shouldn't be a problem. I currently have the following tables:

ls music*
music_albumart.MYD  music_albums.frm       music_directories.MYI 
music_playlists.MYD  music_radios.frm                   
music_smartplaylist_items.MYI  music_songs.MYD  music_stats.frm
music_albumart.MYI  music_artists.MYD      music_directories.frm 
music_playlists.MYI  music_smartplaylist_categories.MYD 
music_smartplaylist_items.frm  music_songs.MYI
music_albumart.frm  music_artists.MYI      music_genres.MYD      
music_playlists.frm  music_smartplaylist_categories.MYI 
music_smartplaylists.MYD       music_songs.frm
music_albums.MYD    music_artists.frm      music_genres.MYI      
music_radios.MYD     music_smartplaylist_categories.frm 
music_smartplaylists.MYI       music_stats.MYD
music_albums.MYI    music_directories.MYD  music_genres.frm      
music_radios.MYI     music_smartplaylist_items.MYD      
music_smartplaylists.frm       music_stats.MYI


-- 
Robin Gilks