[mythtv] Important information concerning DataDirect's outage

Bruce Markey bjm at lvcm.com
Wed Dec 28 22:58:34 EST 2005

Zap2It appears to be suffering some system problems today. This
may cause unfortunate problems when running "mythfilldatabase"
for DataDirect video sources. The grab may appear to succeed and
mythfilldatabase may clear data for the target date, however, the
new data file may be empty. Mfdb normally updates the following
day (tomorrow) and the last day two weeks from now. Therefore, if
you ran mfdb today while Zap2It has this problem, it may delete
all your listing for tomorrow.

I would recommend the following:

1) Go to Setup->General and find the page for "Mythfilldatabase"
and uncheck "Automatically run mythfilldatabase". The options
will disappear from the screen but the values are stored and will
return when you check this box again. If you run mfdb from cron,
disable the cron job temporarily. In either case, don't run mfdb
automatically overnight until there is some verification that the
problem has been fixed.

2) Make a backup of your current "program" table that can be
restored in case data is lost in the next few days.

$ mysqldump -tc -u mythtv -pmythtv mythconverg program > program.sql

If needed, this can be restored with:

$ mysql -u mythtv -pmythtv mythconverg -e "delete from program;" 
$ mysql -u mythtv -pmythtv mythconverg < program.sql
$ mythbackend --resched

3) If you've already lost program data and have a mysql backup from
within the past week or so:

$ grep "INSERT INTO \`program\` " mythtv_backup.sql > tmp_program.sql

This "tmp_program.sql" file can be restored as above. Older versions
of mysqlbackup may not use the backquotes so the grep string would
be "INSERT INTO program ".

--  bjm

More information about the mythtv-dev mailing list