[mythtv-users] mysql filling up hard drive

[Michael T. Dean]

On 05/08/2015 05:34 PM, Bill Meek wrote:
> On 05/08/2015 04:26 PM, Scott Moncrieff wrote:
>> I will have a look at mysqltuner but Is it likely that something is is
>> wrong with the database? There are a large number of errors in the log
>> trying to delete recordings that are not there. I have had a look at the
>> drive that the recordings are stored on and these are all  files that 
>> have
>> been watched and then deleted. Obviously still present in the 
>> database. The
>> thumb nails for all the video files are still present on the drive 
>> though
>> but the recordings are long gone.
>>
>> Would manually deleting all of these entries from the 'recored' table 
>> be a
>> bad idea?
>
>
> Yes, it's a bad idea because it wouldn't clear out, for example the 
> recordedseek
> table.

Right.  Use the find_orphans.py script:

https://www.mythtv.org/wiki/Find_orphans.py

to clean up orphaned recordings or orphaned files.  It actually tells 
the backend to delete the recordings even though the files aren't there, 
and the backend does it properly (and completely).

Alternatively, you can manually delete them from Watch Recordings or 
Delete Recordings, but if you have a lot, it would take a lot of time to 
find them and delete them individually, and since the files aren't 
there, you'd have to go through an extra "are you sure" confirmation 
that tells you the files aren't there.

Mike