How to Flush the "EPG" Data in TV3 (1 Viewer)

[SimonDen]

Hi Hemin - try this

create a textpad document in the mediaportal folder and paste in the following on 1 line:

sqlcmd -S yourservername\SQLEXPRESS -U sa -P yourpassword -Q "DELETE FROM TVLIBRARY.DBO.PROGRAM"

remember to change the "yourservername", "yourpassword" and "sa" (if you changed the standard User ID when installing MP).

Note that the -S -P -U -Q are case sensitive and must be in upper case

rename the .txt to .bat and then use XP Scheduler to run the file.

 

[level20peon]

I don't know if anyone is interested but I just did some cleanup in my subscriptions and stumbled over this old thread. The correct syntax for flushing the EPG Data in MySQL, however is

DELETE FROM program;

-level20peon

 

[Paranoid Delusion]

For MySQL this is a nice simple editor "NavicatLite", that works with no config\setup at all, also makes deleting the db for a clean install a dream.

Use this at your own risk, you can totally screw TVE3, if you do not know what you are doing.

Regards

 

[level20peon]

I am actually using NaviCat MySQL. Just wanted to add the _topic-related_ answer


-level20peon