[mythtv-users] Dumping mythmusic's database

[R. G. Newbury]

On 03/17/2012 11:46 PM, Bob K Mertz wrote:

> 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


Ohh! You meant the 'nuke it from orbit' dump method. ;-)

G.


-- 
              R. Geoffrey Newbury