[mythtv-users] Corrupt cardinput and jobqueue tables

John Taggart john at lackof.org
Fri Jul 6 04:20:02 UTC 2012


I recently noticed that my myth install hasn't been recording shows in 
recent history.  A little more investigation shows that I have some 
corrupt tables in my database.  After searching the archives I can see 
that the answer is "restore from your most recent backup"  Unfortunately 
I haven't backed up for some time.  Is there a way to restore specific 
tables from previous backups?  It looks like it's only the cardinput and 
jobqueque tables are corrupt.

John

mythtv~$ mysqlcheck -ao --auto-repair -u mythtv -p mythconverg
mythconverg.archiveitems                           Table is already up 
to date
mythconverg.callsignnetworkmap                     Table is already up 
to date
mythconverg.capturecard                            Table is already up 
to date
mythconverg.cardinput
Error    : Incorrect file format 'cardinput'
error    : Corrupt
mythconverg.channel                                Table is already up 
to date
mythconverg.channelgroup                           Table is already up 
to date
mythconverg.channelgroupnames                      Table is already up 
to date
mythconverg.channelscan                            Table is already up 
to date
mythconverg.channelscan_channel                    Table is already up 
to date
mythconverg.channelscan_dtv_multiplex              Table is already up 
to date
mythconverg.codecparams                            Table is already up 
to date
mythconverg.credits                                Table is already up 
to date
mythconverg.customexample                          Table is already up 
to date
mythconverg.diseqc_config                          Table is already up 
to date
mythconverg.diseqc_tree                            Table is already up 
to date
mythconverg.displayprofilegroups                   Table is already up 
to date
mythconverg.displayprofiles                        Table is already up 
to date
mythconverg.dtv_multiplex                          Table is already up 
to date
mythconverg.dtv_privatetypes                       Table is already up 
to date
mythconverg.dvdbookmark                            Table is already up 
to date
mythconverg.dvdinput                               Table is already up 
to date
mythconverg.dvdtranscode                           Table is already up 
to date
mythconverg.eit_cache                              Table is already up 
to date
mythconverg.filemarkup                             Table is already up 
to date
mythconverg.gallerymetadata                        Table is already up 
to date
mythconverg.gamemetadata                           Table is already up 
to date
mythconverg.gameplayers                            Table is already up 
to date
mythconverg.housekeeping                           Table is already up 
to date
mythconverg.inputgroup                             Table is already up 
to date
mythconverg.inuseprograms
Error    : Can't find file: './mythconverg/inuseprograms.frm' (errno: 5)
status   : Operation failed
mythconverg.jobqueue
Error    : Incorrect file format 'jobqueue'
error    : Corrupt
mythconverg.jumppoints                             Table is already up 
to date
mythconverg.keybindings                            Table is already up 
to date
mythconverg.keyword                                Table is already up 
to date
mythconverg.mamemetadata                           Table is already up 
to date
mythconverg.mamesettings                           Table is already up 
to date
mythconverg.movies_movies                          Table is already up 
to date
mythconverg.movies_showtimes                       Table is already up 
to date
mythconverg.movies_theaters                        Table is already up 
to date
mythconverg.music_albumart                         Table is already up 
to date
mythconverg.music_albums                           Table is already up 
to date
mythconverg.music_artists                          Table is already up 
to date
mythconverg.music_directories                      Table is already up 
to date
mythconverg.music_genres                           Table is already up 
to date
mythconverg.music_playlists                        Table is already up 
to date
mythconverg.music_smartplaylist_categories         Table is already up 
to date
mythconverg.music_smartplaylist_items              Table is already up 
to date
mythconverg.music_smartplaylists                   Table is already up 
to date
mythconverg.music_songs                            Table is already up 
to date
mythconverg.music_stats                            Table is already up 
to date
mythconverg.mythlog                                Table is already up 
to date
mythconverg.mythweb_sessions                       Table is already up 
to date
mythconverg.neskeyword                             Table is already up 
to date
mythconverg.nestitle                               Table is already up 
to date
mythconverg.netflix                                Table is already up 
to date
mythconverg.networkiconmap                         Table is already up 
to date
mythconverg.newssites                              Table is already up 
to date
mythconverg.oldfind                                Table is already up 
to date
mythconverg.oldprogram                             Table is already up 
to date
mythconverg.oldrecorded                            Table is already up 
to date
mythconverg.people                                 Table is already up 
to date
mythconverg.phonecallhistory                       Table is already up 
to date
mythconverg.phonedirectory                         Table is already up 
to date
mythconverg.pidcache                               Table is already up 
to date
mythconverg.playgroup                              Table is already up 
to date
mythconverg.powerpriority                          Table is already up 
to date
mythconverg.profilegroups                          Table is already up 
to date
mythconverg.program                                Table is already up 
to date
mythconverg.programgenres                          Table is already up 
to date
mythconverg.programrating                          Table is already up 
to date
mythconverg.recgrouppassword                       Table is already up 
to date
mythconverg.record                                 Table is already up 
to date
mythconverg.record_tmp                             Table is already up 
to date
mythconverg.recorded                               Table is already up 
to date
mythconverg.recordedcredits                        Table is already up 
to date
mythconverg.recordedfile                           Table is already up 
to date
mythconverg.recordedmarkup                         Table is already up 
to date
mythconverg.recordedprogram                        Table is already up 
to date
mythconverg.recordedrating                         Table is already up 
to date
mythconverg.recordedseek                           Table is already up 
to date
mythconverg.recordingprofiles                      Table is already up 
to date
mythconverg.recordmatch                            Table is already up 
to date
mythconverg.romdb                                  Table is already up 
to date
mythconverg.schemalock                             Table is already up 
to date
mythconverg.settings                               Table is already up 
to date
mythconverg.snessettings                           Table is already up 
to date
mythconverg.storagegroup                           Table is already up 
to date
mythconverg.tvchain                                Table is already up 
to date
mythconverg.tvosdmenu                              Table is already up 
to date
mythconverg.upnpmedia                              Table is already up 
to date
mythconverg.videocast                              Table is already up 
to date
mythconverg.videocategory                          Table is already up 
to date
mythconverg.videocountry                           Table is already up 
to date
mythconverg.videogenre                             Table is already up 
to date
mythconverg.videometadata                          Table is already up 
to date
mythconverg.videometadatacast                      Table is already up 
to date
mythconverg.videometadatacountry                   Table is already up 
to date
mythconverg.videometadatagenre                     Table is already up 
to date
mythconverg.videosource                            Table is already up 
to date
mythconverg.videotypes                             Table is already up 
to date
mythconverg.weatherdatalayout
note     : Table does not support optimize, doing recreate + analyze instead
status   : OK
mythconverg.weatherscreens
note     : Table does not support optimize, doing recreate + analyze instead
status   : OK
mythconverg.weathersourcesettings
note     : Table does not support optimize, doing recreate + analyze instead
status   : OK
mythconverg.websites                               Table is already up 
to date

Repairing tables
mythconverg.cardinput
Error    : Incorrect file format 'cardinput'
error    : Corrupt
mythconverg.inuseprograms
Error    : Can't find file: './mythconverg/inuseprograms.frm' (errno: 5)
status   : Operation failed
mythconverg.jobqueue
Error    : Incorrect file format 'jobqueue'
error    : Corrupt



More information about the mythtv-users mailing list