[mythtv-users] Dumping mythmusic's database

Bob K Mertz lists at bibleboy.org
Sun Mar 18 03:46:56 UTC 2012


On 3/17/12 7:22 PM, Bob K Mertz wrote:
> I just did an upgrade on my Mythbuntu system which is using 0.25 and
> this upgrade switch me from master to the .25 beta.  I had previously
> had an issue with the mythmusic database which I hadn't really been
> using so I just uninstalled the plugin and everything worked great....
> well, now I have issues.  If I'm gathering things correctly mythmusic is
> no longer a plugin so now I'm right back to the issue I had before but
> can't simply uninstall a plugin, correct?
>
> Here is what I'm getting on the front end:
>
> Mar 17 19:20:06 myth-bay mythfrontend[2282]: C CoreContext
> schemawizard.cpp:135 (CompareAndWait) MythMusic database schema is old.
> Waiting to see if DB is being upgraded.
> Mar 17 19:20:07 myth-bay mythfrontend[2282]: I CoreContext
> mythdbcon.cpp:75 (MSqlDatabase) Database connection created: DBManager4
> Mar 17 19:20:07 myth-bay mythfrontend[2282]: I CoreContext
> mythdbcon.cpp:298 (popConnection) New DB connection, total: 4
> Mar 17 19:20:07 myth-bay mythfrontend[2282]: I CoreContext
> mythdbcon.cpp:179 (OpenDatabase) Connected to database 'mythconverg' at
> host: 192.168.204.50
> Mar 17 19:20:07 myth-bay mythfrontend[2282]: I CoreContext
> schemawizard.cpp:117 (Compare) Current MythMusic Schema Version
> (MusicDBSchemaVer): 1017
> Mar 17 19:20:09  mythfrontend[2282]: last message repeated 2 times
> Mar 17 19:20:09 myth-bay mythfrontend[2282]: C CoreContext
> schemawizard.cpp:179 (CompareAndWait) Timed out waiting.
> Mar 17 19:20:09 myth-bay mythfrontend[2282]: E CoreContext
> storagegroup.cpp:680 (FindNextDirMostFree) SG(Default):
> FindNextDirMostFree: '/var/lib/mythtv/recordings2' does not exist!
> Mar 17 19:20:09 myth-bay mythfrontend[2282]: E CoreContext
> dbutil.cpp:603 (DoBackup) Backing up database with script:
> '/usr/share/mythtv/mythconverg_backup.pl'
>
>
> After that, the process crashes and restarts.
>

I was finally able to resolve this by issuing:

cat << "EOF" | mysql -umythtv -p mythconverg DROP TABLE IF EXISTS 
musicmetadata;
DROP TABLE IF EXISTS musicplaylist;
DROP TABLE IF EXISTS smartplaylistcategory;
DROP TABLE IF EXISTS smartplaylist;
DROP TABLE IF EXISTS smartplaylistitem;
DROP TABLE IF EXISTS music_albums;
DROP TABLE IF EXISTS music_artists;
DROP TABLE IF EXISTS music_genres;
DROP TABLE IF EXISTS music_playlists;
DROP TABLE IF EXISTS music_songs;
DROP TABLE IF EXISTS music_stats;
DROP TABLE IF EXISTS music_smartplaylists;
DROP TABLE IF EXISTS music_smartplaylist_items;
DROP TABLE IF EXISTS music_smartplaylist_categories;
DROP TABLE IF EXISTS music_directories;
DROP TABLE IF EXISTS music_albumart;
DELETE FROM settings WHERE value = 'MusicDBSchemaVer';
EOF



More information about the mythtv-users mailing list