Mythconverg corrupt

[dmbgo]

Hi, I have a corrupt, but useable mythconverg database. For the last few months the backup has been failing, causing mysql and mythbackend to stop. Instead of just restoring a backup of the database when the problem 1st occured, I found that restarting the mysql server and mythbackend worked around the problem.
This became a routine before using myth and wasn't really an issue until a new version of mysql came along. When trying to install the upgrade to mysql, it fails when running queries against the mythconverg database.
Oh no, now I have many recordings that I don't want to lose the info for, no backup of mythconverg and no way to upgrade the mysql server. I have engaged in the requisite number of self recriminations, I used to professionally support enterprise servers, so I am aware of the consequences of not having good backups etc.
Of course I also knew that this would never happen to me.....

Help


Regards
David Maher

[bill6502]

Ouch, does this help: sudo /usr/bin/mysqlcheck --defaults-extra-file=/etc/mysql/debian.cnf mythconverg
mysqlrepair if that fails.

[dmbgo]

Thanks for the reply Bill,
The first command is certainly faster than the mysqlcheck script that I was using.
The first command exits with some missing tables in the mysql database. Can I just recreate these missing tables? If so, could you give me the syntax for the commands? I don't actually use Mythweather or Mythweb much.
Here are the errors that come after the last successful check "mythconverg.videotypes OK"
mythconverg.weatherdatalayout
Error : Table 'mythconverg.weatherdatalayout' doesn't exist
status : Operation failed
mythconverg.weatherscreens
Error : Table 'mythconverg.weatherscreens' doesn't exist
status : Operation failed
mythconverg.weathersourcesettings
Error : Table 'mythconverg.weathersourcesettings' doesn't exist
status : Operation failed
mythconverg.websites
Error : Table 'mythconverg.websites' doesn't exist
status : Operation failed

I'll try the second command you provided now, but it might complain about missing tables as well.

[dmbgo]

Here is the output of the following command, I think I could have avoided some of the errors by telling it to only repair mythconverg:

myth@myth-server:~$ sudo mysqlrepair -A --auto-repair

mysql.columns_priv OK
mysql.db OK
mysql.engine_cost
note : The storage engine for the table doesn't support repair
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed
Warning : Please do not modify the gtid_executed table. This is a mysql internal system table to store GTIDs for committed transactions. Modifying it can lead to an inconsistent GTID state.
note : The storage engine for the table doesn't support repair
mysql.help_category
note : The storage engine for the table doesn't support repair
mysql.help_keyword
note : The storage engine for the table doesn't support repair
mysql.help_relation
note : The storage engine for the table doesn't support repair
mysql.help_topic
note : The storage engine for the table doesn't support repair
mysql.innodb_index_stats
note : The storage engine for the table doesn't support repair
mysql.innodb_table_stats
note : The storage engine for the table doesn't support repair
mysql.ndb_binlog_index OK
mysql.plugin
note : The storage engine for the table doesn't support repair
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.server_cost
note : The storage engine for the table doesn't support repair
mysql.servers
note : The storage engine for the table doesn't support repair
mysql.slave_master_info
note : The storage engine for the table doesn't support repair
mysql.slave_relay_log_info
note : The storage engine for the table doesn't support repair
mysql.slave_worker_info
note : The storage engine for the table doesn't support repair
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone
note : The storage engine for the table doesn't support repair
mysql.time_zone_leap_second
note : The storage engine for the table doesn't support repair
mysql.time_zone_name
note : The storage engine for the table doesn't support repair
mysql.time_zone_transition
note : The storage engine for the table doesn't support repair
mysql.time_zone_transition_type
note : The storage engine for the table doesn't support repair
mysql.user OK
mythconverg.archiveitems
Error : Table 'mythconverg.archiveitems' doesn't exist
status : Operation failed
mythconverg.bdbookmark OK
mythconverg.capturecard OK
mythconverg.cardinput OK
mythconverg.channel OK
mythconverg.channelgroup OK
mythconverg.channelgroupnames OK
mythconverg.channelscan OK
mythconverg.channelscan_channel OK
mythconverg.channelscan_dtv_multiplex OK
mythconverg.codecparams OK
mythconverg.credits OK
mythconverg.customexample OK
mythconverg.diseqc_config OK
mythconverg.diseqc_tree OK
mythconverg.displayprofilegroups OK
mythconverg.displayprofiles OK
mythconverg.dtv_multiplex OK
mythconverg.dtv_privatetypes OK
mythconverg.dvdbookmark OK
mythconverg.dvdinput OK
mythconverg.dvdtranscode OK
mythconverg.eit_cache OK
mythconverg.filemarkup OK
mythconverg.gallery_directories OK
mythconverg.gallery_files OK
mythconverg.gallerymetadata
Error : Table 'mythconverg.gallerymetadata' doesn't exist
status : Operation failed
mythconverg.gamemetadata
Error : Table 'mythconverg.gamemetadata' doesn't exist
status : Operation failed
mythconverg.gameplayers
Error : Table 'mythconverg.gameplayers' doesn't exist
status : Operation failed
mythconverg.housekeeping OK
mythconverg.inputgroup OK
mythconverg.internetcontent OK
mythconverg.internetcontentarticles OK
mythconverg.inuseprograms OK
mythconverg.iptv_channel OK
mythconverg.jobqueue OK
mythconverg.jumppoints OK
mythconverg.keybindings OK
mythconverg.keyword OK
mythconverg.livestream OK
mythconverg.logging OK
mythconverg.music_albumart
Error : Table 'mythconverg.music_albumart' doesn't exist
status : Operation failed
mythconverg.music_albums
Error : Table 'mythconverg.music_albums' doesn't exist
status : Operation failed
mythconverg.music_artists
Error : Table 'mythconverg.music_artists' doesn't exist
status : Operation failed
mythconverg.music_directories
Error : Table 'mythconverg.music_directories' doesn't exist
status : Operation failed
mythconverg.music_genres
Error : Table 'mythconverg.music_genres' doesn't exist
status : Operation failed
mythconverg.music_playlists
Error : Table 'mythconverg.music_playlists' doesn't exist
status : Operation failed
mythconverg.music_radios
Error : Table 'mythconverg.music_radios' doesn't exist
status : Operation failed
mythconverg.music_smartplaylist_categories
Error : Table 'mythconverg.music_smartplaylist_categories' doesn't exist
status : Operation failed
mythconverg.music_smartplaylist_items
Error : Table 'mythconverg.music_smartplaylist_items' doesn't exist
status : Operation failed
mythconverg.music_smartplaylists
Error : Table 'mythconverg.music_smartplaylists' doesn't exist
status : Operation failed
mythconverg.music_songs
Error : Table 'mythconverg.music_songs' doesn't exist
status : Operation failed
mythconverg.music_stats
Error : Table 'mythconverg.music_stats' doesn't exist
status : Operation failed
mythconverg.music_streams
Error : Table 'mythconverg.music_streams' doesn't exist
status : Operation failed
mythconverg.mythlog OK
mythconverg.newssites
Error : Table 'mythconverg.newssites' doesn't exist
status : Operation failed
mythconverg.oldfind OK
mythconverg.oldprogram OK
mythconverg.oldrecorded OK
mythconverg.people OK
mythconverg.pidcache OK
mythconverg.playgroup OK
mythconverg.powerpriority OK
mythconverg.profilegroups OK
mythconverg.program OK
mythconverg.programgenres OK
mythconverg.programrating OK
mythconverg.recgrouppassword OK
mythconverg.recgroups OK
mythconverg.record OK
mythconverg.recorded OK
mythconverg.recordedartwork OK
mythconverg.recordedcredits OK
mythconverg.recordedfile OK
mythconverg.recordedmarkup OK
mythconverg.recordedprogram OK
mythconverg.recordedrating OK
mythconverg.recordedseek OK
mythconverg.recordfilter OK
mythconverg.recordingprofiles OK
mythconverg.recordmatch OK
mythconverg.romdb
Error : Table 'mythconverg.romdb' doesn't exist
status : Operation failed
mythconverg.scannerfile OK
mythconverg.scannerpath OK
mythconverg.settings OK
mythconverg.storagegroup OK
mythconverg.tvchain OK
mythconverg.tvosdmenu
Error : Incorrect file format 'tvosdmenu'
error : Corrupt
mythconverg.upnpmedia
Error : Incorrect file format 'upnpmedia'
error : Corrupt
mythconverg.user_permissions
Error : Incorrect file format 'user_permissions'
error : Corrupt
mythconverg.user_sessions
Error : Incorrect file format 'user_sessions'
error : Corrupt
mythconverg.users
Error : Incorrect file format 'users'
error : Corrupt
mythconverg.videocast OK
mythconverg.videocategory OK
mythconverg.videocollection OK
mythconverg.videocountry OK
mythconverg.videogenre OK
mythconverg.videometadata OK
mythconverg.videometadatacast OK
mythconverg.videometadatacountry OK
mythconverg.videometadatagenre OK
mythconverg.videopart OK
mythconverg.videopathinfo OK
mythconverg.videosource OK
mythconverg.videotypes OK
mythconverg.weatherdatalayout
Error : Table 'mythconverg.weatherdatalayout' doesn't exist
status : Operation failed
mythconverg.weatherscreens
Error : Table 'mythconverg.weatherscreens' doesn't exist
status : Operation failed
mythconverg.weathersourcesettings
Error : Table 'mythconverg.weathersourcesettings' doesn't exist
status : Operation failed
mythconverg.websites
Error : Table 'mythconverg.websites' doesn't exist
status : Operation failed

[dmbgo]

Perhaps I would be better off recreating the database after exporting the recordings? Is this possible?