[mythtv] Database corruption, maybe

[David Highley]

After restoring two different database back ups we are still seeing
these errors.

Did the restore this way:
/usr/share/mythtv/mythconverg_restore.pl --verbose --drop_database --create_database --filename mythconverg-1317-20140118020702.sql.gz

Restore indicated it was successfull both times.

2014-01-19 21:34:23.340221 I [21567/21583] Scheduler scheduler.cpp:2096 (HandleR
eschedule) - Reschedule requested for MATCH 0 0 0 - SchedulerInit
2014-01-19 21:34:23.346403 E [21567/21583] Scheduler mythdb.cpp:183 (DBError) - 
DB Error (Creating sched_temp_record table):
Query was:
CREATE TEMPORARY TABLE sched_temp_record LIKE record;
Driver error was [2/1049]:
QMYSQL3: Unable to execute statement
Database error was:
Unknown database 'mythconverg'

2014-01-19 21:34:23.346834 E [21567/21583] Scheduler mythdbcon.cpp:837 (prepare) - Error preparing query: UPDATE recordmatch  INNER JOIN sched_temp_record ON (recordmatch.recordid = sched_temp_record.recordid)  INNER JOIN program p ON (recordmatch.chanid = p.chanid AND                           recordmatch.starttime = p.starttime AND                           recordmatch.manualid = p.manualid)  LEFT JOIN oldrecorded ON   (     sched_temp_record.dupmethod > 1 AND     oldrecorded.duplicate <> 0 AND     p.title = oldrecorded.title AND     p.generic = 0      AND      (       (p.programid <> ''        AND p.programid = oldrecorded.programid)       OR       (        (p.programid = '' OR oldrecorded.programid = '')        AND        (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> ''           AND p.subtitle = oldrecorded.subtitle))        AND        (((sched_temp_record.dupmethod & 0x04) = 0) OR (p.description <> ''           AND p.description = oldrecorded.descriptio!
 n))        AND        (((sched_temp_record.dupmethod & 0x08) = 0) OR           (p.subtitle <> '' AND              (p.subtitle = oldrecorded.subtitle OR               (oldrecorded.subtitle = '' AND                p.subtitle = oldrecorded.description))) OR           (p.subtitle = '' AND p.description <> '' AND              (p.description = oldrecorded.subtitle OR               (oldrecorded.subtitle = '' AND                p.description = oldrecorded.description))))       )      )   )  LEFT JOIN sched_temp_recorded recorded ON   (     sched_temp_record.dupmethod > 1 AND     recorded.duplicate <> 0 AND     p.title = recorded.title AND     p.generic = 0 AND     recorded.recgroup NOT IN ('LiveTV','Deleted')      AND      (       (p.programid <> ''        AND p.programid = recorded.programid)       OR       (        (p.programid = '' OR recorded.programid = '')        AND        (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> ''           AND p.subtitle = recorded.su!
 btitle))        AND        (((sch
2014-01-19 21:34:23.346855 E [21567/21583] Scheduler mythdbcon.cpp:839 (prepare) - Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.sched_temp_record' doesn't exist

2014-01-19 21:34:23.347256 E [21567/21583] Scheduler mythdb.cpp:183 (DBError) - DB Error (UpdateDuplicates):
Query was:
UPDATE recordmatch  INNER JOIN sched_temp_record ON (recordmatch.recordid = sched_temp_record.recordid)  INNER JOIN program p ON (recordmatch.chanid = p.chanid AND                           recordmatch.starttime = p.starttime AND                           recordmatch.manualid = p.manualid)  LEFT JOIN oldrecorded ON   (     sched_temp_record.dupmethod > 1 AND     oldrecorded.duplicate <> 0 AND     p.title = oldrecorded.title AND     p.generic = 0      AND      (       (p.programid <> ''        AND p.programid = oldrecorded.programid)       OR       (        (p.programid = '' OR oldrecorded.programid = '')        AND        (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> ''           AND p.subtitle = oldrecorded.subtitle))        AND        (((sched_temp_record.dupmethod & 0x04) = 0) OR (p.description <> ''           AND p.description = oldrecorded.description))        AND        (((sched_temp_record.dupmethod & 0x08) = 0) OR           (p.subtitle <> '' AND      !
         (p.subtitle = oldrecorded.subtitle OR               (oldrecorded.subtitle = '' AND                p.subtitle = oldrecorded.description))) OR           (p.subtitle = '' AND p.description <> '' AND              (p.description = oldrecorded.subtitle OR               (oldrecorded.subtitle = '' AND                p.description = oldrecorded.description))))       )      )   )  LEFT JOIN sched_temp_recorded recorded ON   (     sched_temp_record.dupmethod > 1 AND     recorded.duplicate <> 0 AND     p.title = recorded.title AND     p.generic = 0 AND     recorded.recgroup NOT IN ('LiveTV','Deleted')      AND      (       (p.programid <> ''        AND p.programid = recorded.programid)       OR       (        (p.programid = '' OR recorded.programid = '')        AND        (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> ''
   AND p.subtitle = recorded.subtitle))        
2014-01-19 21:34:23.347409 E [21567/21583] Scheduler mythdbcon.cpp:837 (prepare) - Error preparing query: SELECT recordid, title, maxepisodes, maxnewest FROM sched_temp_record
2014-01-19 21:34:23.347420 E [21567/21583] Scheduler mythdbcon.cpp:839 (prepare) - Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.sched_temp_record' doesn't exist

2014-01-19 21:34:23.347540 E [21567/21583] Scheduler mythdb.cpp:183 (DBError) - DB Error (CheckTooMany):
Query was:
SELECT recordid, title, maxepisodes, maxnewest FROM sched_temp_record
Driver error was [2/1146]:
QMYSQL: Unable to execute query
Database error was:
Table 'mythconverg.sched_temp_record' doesn't exist