[mythtv-users] no scheduling data in UI following db restore

[Michael T. Dean]

On 03/28/2011 06:53 PM, Richard Morton wrote:
> more complete log from mythbackend with the scheduling results...
...
> 2011-03-28 23:47:13.605 Error preparing query: UPDATE oldrecorded SET
> recstatus = :RSABORTED   WHERE recstatus = :RSRECORDING
> 2011-03-28 23:47:13.606 Driver error was [2/144]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Table './mythconverg/oldrecorded' is marked as crashed and last
> (automatic?) repair failed

mysqlcheck -r , see mysql documentation for details

You will likely lose some information (recorded history) in the repair, 
so may end up with re-recorded shows you have to delete (or Never Record 
before the record).

Mike