On 10/26/11 17:53, Michael Schreckenbauer wrote: > Am Mittwoch, 26. Oktober 2011, 17:42:14 schrieb Michael Sullivan: >> On 10/26/11 17:32, Michael Schreckenbauer wrote: >>> So you did run mysql_upgrade and same as before? Some words about what >>> you did and some relevant output of the command (if any) wouldn't hurt >>> ;) Have you tried mysql_fix_privilege_tables? After that, you would >>> need to run the steps mentioned in the wiki again (I think), giving the >>> password you entered in myth-setup to the UPDATE command. >>> >>> Best, >>> Michael >> >> camille ~ # mysql_upgrade -p >> Enter password: >> Looking for 'mysql' as: mysql >> Looking for 'mysqlcheck' as: mysqlcheck >> Running 'mysqlcheck' with connection arguments: '--port=3306' >> '--socket=/var/run/mysqld/mysqld.sock' >> Failed to ALTER DATABASE `#mysql50#mythconverg.bak` UPGRADE DATA >> DIRECTORY NAME >> Error: Incorrect database name '#mysql50#mythconverg.bak' >> Running 'mysqlcheck' with connection arguments: '--port=3306' >> '--socket=/var/run/mysqld/mysqld.sock' >> forum.phpbb_auth_access >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_auth_access`" or dump/reload to fix it! >> forum.phpbb_banlist >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_banlist`" or dump/reload to fix it! >> forum.phpbb_categories >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_categories`" or dump/reload to fix it! >> forum.phpbb_config >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_config`" or dump/reload to fix it! >> forum.phpbb_confirm >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_confirm`" or dump/reload to fix it! >> forum.phpbb_disallow >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_disallow`" or dump/reload to fix it! >> forum.phpbb_forum_prune >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_forum_prune`" or dump/reload to fix it! >> forum.phpbb_forums >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_forums`" or dump/reload to fix it! >> forum.phpbb_groups >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_groups`" or dump/reload to fix it! >> forum.phpbb_posts >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_posts`" or dump/reload to fix it! >> forum.phpbb_posts_text >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_posts_text`" or dump/reload to fix it! >> forum.phpbb_privmsgs >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_privmsgs`" or dump/reload to fix it! >> forum.phpbb_privmsgs_text >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_privmsgs_text`" or dump/reload to fix it! >> forum.phpbb_ranks >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_ranks`" or dump/reload to fix it! >> forum.phpbb_search_results >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_search_results`" or dump/reload to fix it! >> forum.phpbb_search_wordlist >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_search_wordlist`" or dump/reload to fix it! >> forum.phpbb_search_wordmatch >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_search_wordmatch`" or dump/reload to fix it! >> forum.phpbb_sessions >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_sessions`" or dump/reload to fix it! >> forum.phpbb_sessions_keys >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_sessions_keys`" or dump/reload to fix it! >> forum.phpbb_smilies >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_smilies`" or dump/reload to fix it! >> forum.phpbb_themes >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_themes`" or dump/reload to fix it! >> forum.phpbb_themes_name >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_themes_name`" or dump/reload to fix it! >> forum.phpbb_topics >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_topics`" or dump/reload to fix it! >> forum.phpbb_topics_watch >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_topics_watch`" or dump/reload to fix it! >> forum.phpbb_user_group >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_user_group`" or dump/reload to fix it! >> forum.phpbb_users >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_users`" or dump/reload to fix it! >> forum.phpbb_vote_desc >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_vote_desc`" or dump/reload to fix it! >> forum.phpbb_vote_results >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_vote_results`" or dump/reload to fix it! >> forum.phpbb_vote_voters >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_vote_voters`" or dump/reload to fix it! >> forum.phpbb_words >> error : Table upgrade required. Please do "REPAIR TABLE >> `phpbb_words`" or dump/reload to fix it! >> movies.also_available >> error : Table upgrade required. Please do "REPAIR TABLE >> `also_available`" or dump/reload to fix it! >> movies.do_not_watch >> error : Table upgrade required. Please do "REPAIR TABLE >> `do_not_watch`" or dump/reload to fix it! >> movies.movies_to_review >> error : Table upgrade required. Please do "REPAIR TABLE >> `movies_to_review`" or dump/reload to fix it! >> movies.reviews >> error : Table upgrade required. Please do "REPAIR TABLE `reviews`" or >> dump/reload to fix it! >> movies.to_do_list >> error : Table upgrade required. Please do "REPAIR TABLE `to_do_list`" >> or dump/reload to fix it! >> myFantasy.actions >> error : Table upgrade required. Please do "REPAIR TABLE `actions`" or >> dump/reload to fix it! >> myFantasy.allyAbilities >> error : Table upgrade required. Please do "REPAIR TABLE >> `allyAbilities`" or dump/reload to fix it! >> myFantasy.characters >> error : Table upgrade required. Please do "REPAIR TABLE `characters`" >> or dump/reload to fix it! >> myFantasy.class >> error : Table upgrade required. Please do "REPAIR TABLE `class`" or >> dump/reload to fix it! >> myFantasy.enemy >> error : Table upgrade required. Please do "REPAIR TABLE `enemy`" or >> dump/reload to fix it! >> myFantasy.enemyAbility >> error : Table upgrade required. Please do "REPAIR TABLE >> `enemyAbility`" or dump/reload to fix it! >> myFantasy.magic >> error : Table upgrade required. Please do "REPAIR TABLE `magic`" or >> dump/reload to fix it! >> myFantasy.party >> error : Table upgrade required. Please do "REPAIR TABLE `party`" or >> dump/reload to fix it! >> mysql.columns_priv OK >> mysql.db OK >> mysql.event OK >> mysql.func OK >> mysql.general_log >> Error : You can't use locks with log tables. >> status : OK >> mysql.help_category >> error : Table upgrade required. Please do "REPAIR TABLE >> `help_category`" or dump/reload to fix it! >> mysql.help_keyword >> error : Table upgrade required. Please do "REPAIR TABLE >> `help_keyword`" or dump/reload to fix it! >> mysql.help_relation >> error : Table upgrade required. Please do "REPAIR TABLE >> `help_relation`" or dump/reload to fix it! >> mysql.help_topic >> error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" >> or dump/reload to fix it! >> 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 : You can't use locks with log tables. >> status : OK >> mysql.tables_priv OK >> mysql.time_zone >> error : Table upgrade required. Please do "REPAIR TABLE `time_zone`" >> or dump/reload to fix it! >> mysql.time_zone_leap_second >> error : Table upgrade required. Please do "REPAIR TABLE >> `time_zone_leap_second`" or dump/reload to fix it! >> mysql.time_zone_name >> error : Table upgrade required. Please do "REPAIR TABLE >> `time_zone_name`" or dump/reload to fix it! >> mysql.time_zone_transition >> error : Table upgrade required. Please do "REPAIR TABLE >> `time_zone_transition`" or dump/reload to fix it! >> mysql.time_zone_transition_type >> error : Table upgrade required. Please do "REPAIR TABLE >> `time_zone_transition_type`" or dump/reload to fix it! >> mysql.user OK >> mysql_cpp_data.images OK >> mysql_cpp_data.stock >> Error : Table 'mysql_cpp_data.stock' doesn't exist >> status : Operation failed >> mythconverg.archiveitems OK >> mythconverg.callsignnetworkmap 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 >> mysqlcheck: Got error: 1102: Incorrect database name >> '#mysql50#mythconverg.bak' when selecting the database >> 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.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.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.mythlog OK >> mythconverg.mythweb_sessions OK >> mythconverg.netflix OK >> mythconverg.networkiconmap OK >> 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.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.tvosdmenu 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 OKcamille ~ # >> mysql_fix_privilege_tables >> This script updates all the mysql privilege tables to be usable by >> the current version of MySQL >> >> done > > So your mythtv-tables are ok afaics. you need to repair your php-bb tables at > some time, but that's a different topic. > From your other post I conclude, that connecting to the backend now works, > but > you don't get a program listing. I'll answer there, to keep things related > together. > > Best, > Michael > >
I spent some time repairing tables. Does this look better? camille ~ # mysql_upgrade -p Enter password: Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' Failed to ALTER DATABASE `#mysql50#mythconverg.bak` UPGRADE DATA DIRECTORY NAME Error: Incorrect database name '#mysql50#mythconverg.bak' Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' myFantasy.actions OK myFantasy.allyAbilities OK myFantasy.characters OK myFantasy.class OK myFantasy.enemy OK myFantasy.enemyAbility OK myFantasy.magic OK myFantasy.party OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log Error : You can't use locks with log tables. status : OK 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 : You can't use locks with log tables. status : OK 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 mysql_cpp_data.images OK mysql_cpp_data.stock Error : Table 'mysql_cpp_data.stock' doesn't exist status : Operation failed mythconverg.archiveitems OK mythconverg.callsignnetworkmap 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.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.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 mysqlcheck: Got error: 1102: Incorrect database name '#mysql50#mythconverg.bak' when selecting the database mythconverg.music_smartplaylists OK mythconverg.music_songs OK mythconverg.music_stats OK mythconverg.mythlog OK mythconverg.mythweb_sessions OK mythconverg.netflix OK mythconverg.networkiconmap OK 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.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.tvosdmenu 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 FATAL ERROR: Upgrade failed
