Should anyone ask, I prefer my TV viewing “auto-expired”

Mythtv was complaining since I hadn’t been setting show’s to auto-expire. 600Gb of recorded content later, it was failing to record new shows because it couldn’t expire old ones to make space.

This was simply solved and one of the reasons that I love mythtv:

mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 15
Server version: 5.0.32-Debian_7-log Debian etch distribution

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> use mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE recorded SET autoexpire = 1 WHERE autoexpire = 0;

Query OK, 231 rows affected (0.02 sec)
Rows matched: 231 Changed: 231 Warnings: 0
mysql> exit
Bye

Done!

Now all my television programs will expire after a couple of weeks to make place for fresher programs.  That is unless I specifically set them to not expire which for some reason I had been.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.