[mythtv-users] Mysql Database problems

[Anthony Giggins]

> On 05/06/07, Anthony Giggins <seven at seven.dorksville.net> wrote:
>> Since a server lockup last night, I've been getting the following
>> problems
>> in the mysql database of mythtv, I cant seem to find any information
>> about
>> repairing them.
>>
>> Please Help
>>
>> from /var/log/mysqld.log
>> 070605 11:39:47 [ERROR] /usr/libexec/mysqld: Incorrect information in
>> file: './mythconverg/dtv_multiplex.frm'
>
> See http://www.mythtv.org/wiki/index.php/User_Manual:Periodic_Maintenance
> especially the section on optimzing the database - the referred script
> will attempt to repair any bad tables it finds.
>
> --
> Nick

Tried this but I'm still getting the same errors, even though the script
said it repaired it

Repaired/Optimized: `archiveitems`
Repaired/Optimized: `callsignnetworkmap`
Repaired/Optimized: `capturecard`
Repaired/Optimized: `cardinput`
Repaired/Optimized: `channel`
Repaired/Optimized: `codecparams`
Repaired/Optimized: `credits`
Repaired/Optimized: `customexample`
Repaired/Optimized: `diseqc_config`
Repaired/Optimized: `diseqc_tree`
Repaired/Optimized: `dtv_multiplex`
Repaired/Optimized: `dtv_privatetypes`
Repaired/Optimized: `dvdinput`
Repaired/Optimized: `dvdtranscode`
Repaired/Optimized: `eit_cache`
Repaired/Optimized: `favorites`
Repaired/Optimized: `filemarkup`
Repaired/Optimized: `gallerymetadata`
Repaired/Optimized: `gamemetadata`
Repaired/Optimized: `gameplayers`
Repaired/Optimized: `housekeeping`
Repaired/Optimized: `inuseprograms`
Repaired/Optimized: `jobqueue`
Repaired/Optimized: `jumppoints`
Repaired/Optimized: `keybindings`
Repaired/Optimized: `keyword`
Repaired/Optimized: `music_albums`
Repaired/Optimized: `music_artists`
Repaired/Optimized: `music_genres`
Repaired/Optimized: `music_playlists`
Repaired/Optimized: `music_smartplaylist_categories`
Repaired/Optimized: `music_smartplaylist_items`
Repaired/Optimized: `music_smartplaylists`
Repaired/Optimized: `music_songs`
Repaired/Optimized: `music_stats`
Repaired/Optimized: `musicmetadata`
Repaired/Optimized: `musicplaylist`
Repaired/Optimized: `mythlog`
Repaired/Optimized: `mythweb_sessions`
Repaired/Optimized: `networkiconmap`
Repaired/Optimized: `oldfind`
Repaired/Optimized: `oldprogram`
Repaired/Optimized: `oldrecorded`
Repaired/Optimized: `people`
Repaired/Optimized: `phonecallhistory`
Repaired/Optimized: `phonedirectory`
Repaired/Optimized: `pidcache`
Repaired/Optimized: `playgroup`
Repaired/Optimized: `profilegroups`
Repaired/Optimized: `program`
Repaired/Optimized: `programgenres`
Repaired/Optimized: `programrating`
Repaired/Optimized: `recgrouppassword`
Repaired/Optimized: `record`
Repaired/Optimized: `recorded`
Repaired/Optimized: `recordedcredits`
Repaired/Optimized: `recordedmarkup`
Repaired/Optimized: `recordedprogram`
Repaired/Optimized: `recordedrating`
Repaired/Optimized: `recordedseek`
Repaired/Optimized: `recordingprofiles`
Repaired/Optimized: `recordmatch`
Repaired/Optimized: `romdb`
Repaired/Optimized: `schemalock`
Repaired/Optimized: `settings`
Repaired/Optimized: `streams`
Repaired/Optimized: `tvchain`
Repaired/Optimized: `videocategory`
Repaired/Optimized: `videocountry`
Repaired/Optimized: `videogenre`
Repaired/Optimized: `videometadata`
Repaired/Optimized: `videometadatacountry`
Repaired/Optimized: `videometadatagenre`
Repaired/Optimized: `videosource`
Repaired/Optimized: `videotypes`
Repaired/Optimized: `websites`