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

[Nick Morrott]

On 15/04/2008, Greg Grotsky <spikeygg at gmail.com> wrote:

> Thanks Nick, sorry about the delay.  I tried the method you outline and I
> get the following message the first time I try to load mythfrontend:
>
> 2008-04-15 06:22:15.710 Upgrading to MythMusic schema version 1006
>  2008-04-15 06:22:15.729 DB Error (Performing database upgrade):
>  Query was: RENAME TABLE smartplaylist TO music_smartplaylists;
>  Error was: Driver error was [2/1017]:
>  QMYSQL: Unable to execute query
>  Database error was:
>  Can't find file: './mythconverg/smartplaylist.frm' (errno:
> 2)

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

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin