[mythtv-users] manually deleting music tables from mysql

[Jeff Mottishaw]

Rather attempt to remember the sql commands and syntaxes, I simply do a
mysqldump > file, drop the database, edit the file (keeping a backup of
course) and then do a mysql < file

Probably not the smartest way of doing things, but its easy :)

Vi is easier for me :)

jeff

 

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Richie Jarvis
Sent: April 7, 2004 1:25 AM
To: Discussion about mythtv
Subject: Re: [mythtv-users] manually deleting music tables from mysql

I have done this on several occasions.  I must admit I used MySQLCC to do
it, but that is because I am lazy ;)

The actual command sequence is:

use mythconverg;
delete from musicmetadata;
delete from musicplaylist;

That should clear both playlists and the music from the database.

Enjoy!

Richie

James Colannino wrote:
> has anyone ever manually deleted the music tables from mysql on the 
> command line before?  I need to clear out all the music I currently 
> have on my machine.  Thanks in advance.
> 
> James
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 
>