[opensuse] hosed mysql
I have a problem with mysql, I'm getting this error: P-733-Lin:/usr/bin # ./mysql_upgrade Looking for 'mysql' in: /usr/bin/mysql Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck Running 'mysqlcheck'... /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect failed FATAL ERROR: Upgrade failed The reason I did this was that I noticed that my mythtv wasn't working and the response that I got from that list indicated this as a solution. So mysql isn't running, and that means mythtv isn't running. What in Puce is this final error that the upgrade failed? What upgrade? I did a security update, not a package upgrade. P-733-Lin:/etc/init.d # rcmysql start Updating MySQL privilege database... Looking for 'mysql' in: /usr/bin/mysql Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck Running 'mysqlcheck'... mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log Error : Can't find file: 'general_log' (errno: 2) error : Corrupt mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.servers OK mysql.slow_log Error : Can't find file: 'slow_log' (errno: 2) error : Corrupt mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK mythconverg.archiveitems OK mythconverg.callsignnetworkmap OK mythconverg.capturecard OK mythconverg.cardinput OK mythconverg.channel 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.favorites OK mythconverg.filemarkup OK mythconverg.gallerymetadata OK mythconverg.gamemetadata OK mythconverg.gameplayers OK mythconverg.housekeeping OK mythconverg.inputgroup OK mythconverg.inuseprograms OK mythconverg.jobqueue OK mythconverg.jumppoints OK mythconverg.keybindings OK mythconverg.keyword OK mythconverg.movies_movies OK mythconverg.movies_showtimes OK mythconverg.movies_theaters OK mythconverg.music_albumart OK mythconverg.music_albums OK mythconverg.music_artists OK mythconverg.music_directories OK mythconverg.music_genres OK mythconverg.music_playlists OK mythconverg.music_smartplaylist_categories OK mythconverg.music_smartplaylist_items OK mythconverg.music_smartplaylists OK mythconverg.music_songs OK mythconverg.music_stats OK mythconverg.musicmetadata OK mythconverg.musicplaylist OK mythconverg.mythlog OK mythconverg.mythweb_sessions OK mythconverg.netflix OK mythconverg.networkiconmap OK mythconverg.oldfind OK /usr/bin/mysqlcheckmythconverg.oldprogram OK mythconverg.oldrecorded OK mythconverg.people OK : mythconverg.phonecallhistory OK mythconverg.phonedirectory OK Got error: 1102: Incorrect database name 'mythconverg.11-02-2009' when selecting the database 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.record OK mythconverg.record_tmp OK mythconverg.recorded OK mythconverg.recordedcredits OK mythconverg.recordedfile OK mythconverg.recordedmarkup OK mythconverg.recordedprogram OK mythconverg.recordedrating OK mythconverg.recordedseek OK mythconverg.recordingprofiles OK mythconverg.recordmatch OK mythconverg.romdb OK mythconverg.schemalock OK mythconverg.settings OK mythconverg.storagegroup OK mythconverg.tvchain OK mythconverg.upnpmedia OK mythconverg.videocast OK mythconverg.videocategory OK mythconverg.videocountry OK mythconverg.videogenre OK mythconverg.videometadata OK mythconverg.videometadatacast OK mythconverg.videometadatacountry OK mythconverg.videometadatagenre OK mythconverg.videosource OK mythconverg.videotypes OK mythconverg.websites OK FATAL ERROR: Upgrade failed -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (1)
-
Mike McMullin