Deleting all Live TV & DVR data from PMS

Live TV & DVR
,
1

Server Version#: 1.23.3.4707
Player Version#: Web
Tuner Make/Model: Hauppage WinTV Nova 2
Guide/Lineup name:
Using XMLTV?:
Channel number/Name:

Hey all

I’m having some issues with Live TV/DVR on my PMS and I’d like to delete all of the data stored in this part of the app, because some of the channels I watch (one in particular) won’t tune so I’d like to “reset” this part and start again.

I’ve seen some info previously which involved using SQL (I’m a developer so comfortable with this) but I’ve lost the bookmark I had.

Is there way to achieve my aim of resetting all PVR/Live TV data?

Thanks!

2

It is a good idea to perform the DB repair before proceeding https://support.plex.tv/articles/repair-a-corrupted-database/

You want to perform this SQL query on the main plex database file (while the server is not running!):
Careful! It removes everything DVR-related.
DELETE FROM media_provider_resources
This is strictly unsupported! It may have side effects.

You can also delete the database files which contain the EPG data.
Simply remove all files with names beginning with tv.plex.providers.epg.cloud... from the database folder.
(But only these files! Otherwise you can say goodbye to all libraries and metadata.)

3

Or you can delete the DVR.

image

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.