[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