Home » Forums » MythDora » Usage

Reset database?

  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:5446e587905e20bc0f3afaecc13c36cc' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>I deleted a few of the video recordings directly from the hard drive and now mythtv shows recordings that do not exist. Is there a way I can delete all the remaining recordings and reset the database to show no recording?</p>\n', created = 1369214118, expire = 1369300518, headers = '', serialized = 0 WHERE cid = '1:5446e587905e20bc0f3afaecc13c36cc' in /var/www/mythdora/html/includes/cache.inc on line 109.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:d10f4be0bab19eab26d266be4bc34106' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>You should always delete your recordings from the Manage Recordings section. This way you won\'t have to go through this. </p>\n<p>\"Please ignore the man behind the curtain\"<br />\nDennis</p>\n', created = 1369214118, expire = 1369300518, headers = '', serialized = 0 WHERE cid = '1:d10f4be0bab19eab26d266be4bc34106' in /var/www/mythdora/html/includes/cache.inc on line 109.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:7ee834acd95a5efc693cacccaa73a62b' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>\"Please ignore the man behind the curtain\"<br />\nDennis</p>\n', created = 1369214118, expire = 1369300518, headers = '', serialized = 0 WHERE cid = '1:7ee834acd95a5efc693cacccaa73a62b' in /var/www/mythdora/html/includes/cache.inc on line 109.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:1db1350ecc5e4dc198fc0830eea5d611' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>Well, I think i figured it out and heres what I did. </p>\n<p>$mysql<br />\n&gt;connect mythconverg;<br />\n&gt;delete from recorded where chanid &gt; -1;<br />\n&gt;exit<br />\n$cd /video<br />\n$rm -f *.nuv<br />\n$rm -f *.png</p>\n<p>That deleted all the entries of recorded shows, then deleted the actual videos, now I can start with a clean slate</p>\n', created = 1369214118, expire = 1369300518, headers = '', serialized = 0 WHERE cid = '1:1db1350ecc5e4dc198fc0830eea5d611' in /var/www/mythdora/html/includes/cache.inc on line 109.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:6f8328d66cdb73ac1141489749c12bee' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>Related to this topic, the following link can be helpful:<br />\n<a href=\"http://mythtv.beirdo.ca/wiki/index.php/FAQ#How_do_I_remove_recordings_that_no_longer_exist_on_disk.3F\">http://mythtv.beirdo.ca/wiki/index.php/FAQ#How_do_I_remove_recordings_that_no_longer_exist_on_disk.3F</a></p>\n<p>It still creates a .nuv file, and if I am not mistaking, this is the file format of MythTV .18 or prior. You might want to change it to .mpg if you are using MythTV 0.19.</p>\n<p>I had bookmarked this once, because I thought it could come in handy for when I have a running MythTV machine.</p>\n', created = 1369214118, expire = 1369300518, headers = '', serialized = 0 WHERE cid = '1:6f8328d66cdb73ac1141489749c12bee' in /var/www/mythdora/html/includes/cache.inc on line 109.
Submitted by gtmurff on June 3, 2006 - 9:27am

I deleted a few of the video recordings directly from the hard drive and now mythtv shows recordings that do not exist. Is there a way I can delete all the remaining recordings and reset the database to show no recording?

‹ mythgame - zsnes &xmame Hauppauge Silver remote ›

You should always delete

Submitted by d00dtv on June 3, 2006 - 10:05am.

You should always delete your recordings from the Manage Recordings section. This way you won't have to go through this.

"Please ignore the man behind the curtain"
Dennis

—

"Please ignore the man behind the curtain"
Dennis

»

Well, I think i figured it

Submitted by gtmurff on June 3, 2006 - 9:57am.

Well, I think i figured it out and heres what I did.

$mysql
>connect mythconverg;
>delete from recorded where chanid > -1;
>exit
$cd /video
$rm -f *.nuv
$rm -f *.png

That deleted all the entries of recorded shows, then deleted the actual videos, now I can start with a clean slate

»

My two cent

Submitted by Roebi on June 6, 2006 - 3:22am.

Related to this topic, the following link can be helpful:
http://mythtv.beirdo.ca/wiki/index.php/FAQ#How_do_I_remove_recordings_that_no_longer_exist_on_disk.3F

It still creates a .nuv file, and if I am not mistaking, this is the file format of MythTV .18 or prior. You might want to change it to .mpg if you are using MythTV 0.19.

I had bookmarked this once, because I thought it could come in handy for when I have a running MythTV machine.

»