明けましておめでとうございます
今年もどうなるか・・・・
MySQL 5.1 を MyISAM ⇒ InnoDB に変更したので
ログを確認すると気になるエラーを発見しました
[ERROR] Plugin 'InnoDB' init function returned error. [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50027, now running 50172. Please use mysql_upgrade to fix this error. [ERROR] mysql.user has no `Event_priv` column at position 29 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
MySQL を変更した場合は、mysql_upgrade を
実行する必要があるらしいです
早速、以下の方法で実行する事にしました
mysql_upgrade -u root -p Warning: mysql_upgrade: Option '--set-variable' is deprecated. Use --variable-name=value instead. Enter password: Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' blog.wp_Counterize OK blog.wp_Counterize_Keywords OK blog.wp_Counterize_Pages OK blog.wp_Counterize_Referers OK blog.wp_Counterize_UserAgents OK blog.wp_ak_404_log OK blog.wp_blc_filters OK blog.wp_blc_instances OK blog.wp_blc_links OK blog.wp_blc_synch OK blog.wp_cbnetpo_ping_optimizer OK blog.wp_commentmeta OK blog.wp_comments OK blog.wp_ewwwio_images OK blog.wp_flickr_post OK blog.wp_ktaisession OK blog.wp_links OK blog.wp_options OK blog.wp_postmeta OK blog.wp_posts OK blog.wp_redirection_groups OK blog.wp_redirection_items OK blog.wp_redirection_logs OK blog.wp_redirection_modules OK blog.wp_similar_posts OK blog.wp_term_relationships OK blog.wp_term_taxonomy OK blog.wp_terms OK blog.wp_usermeta OK blog.wp_users OK blogweb.bpd1d039_access OK blogweb.bpd1d039_categorygroup OK blogweb.bpd1d039_categorylist OK blogweb.bpd1d039_commentdata OK blogweb.bpd1d039_commentlist OK blogweb.bpd1d039_denyip OK blogweb.bpd1d039_filelist OK blogweb.bpd1d039_init OK blogweb.bpd1d039_linkgroup OK blogweb.bpd1d039_linklist OK blogweb.bpd1d039_logdata OK blogweb.bpd1d039_loglist OK blogweb.bpd1d039_mod_archives_cache OK blogweb.bpd1d039_mod_archives_init OK blogweb.bpd1d039_mod_categorylist_cache OK blogweb.bpd1d039_mod_linkslist_cache OK blogweb.bpd1d039_mod_newentry_cache OK blogweb.bpd1d039_mod_newentry_init OK blogweb.bpd1d039_mod_profilelist_cache OK blogweb.bpd1d039_mod_recomment_cache OK blogweb.bpd1d039_mod_recomment_init OK blogweb.bpd1d039_mod_retrackback_cache OK blogweb.bpd1d039_mod_retrackback_init OK blogweb.bpd1d039_module OK blogweb.bpd1d039_pinglist OK blogweb.bpd1d039_profile OK blogweb.bpd1d039_skinlist OK blogweb.bpd1d039_trackback OK blogweb.bpd1d039_userlist OK blogweb.bpd1d039_viewskin OK blogweb.bpd1d039_viewskin_mobile OK comex.address_book OK comex.address_format OK comex.admin OK comex.admin_activity_log OK comex.authorizenet OK comex.banners OK comex.banners_history OK comex.blocks OK comex.categories OK comex.categories_description OK comex.configuration OK comex.configuration_group OK comex.counter OK comex.counter_history OK comex.countries OK comex.coupon_email_track OK comex.coupon_gv_customer OK comex.coupon_gv_queue OK comex.coupon_redeem_track OK comex.coupon_restrict OK comex.coupons OK comex.coupons_description OK comex.currencies OK comex.customers OK comex.customers_basket OK comex.customers_basket_attributes OK comex.customers_info OK comex.customers_wishlist OK comex.db_cache OK comex.email_archive OK comex.ezpages OK comex.featured OK comex.files_uploaded OK comex.geo_zones OK comex.get_terms_to_filter OK comex.group_pricing OK comex.languages OK comex.layout_boxes OK comex.manufacturers OK comex.manufacturers_info OK comex.media_clips OK comex.media_manager OK comex.media_to_products OK comex.media_types OK comex.meta_tags_categories_description OK comex.meta_tags_products_description OK comex.music_genre OK comex.newsletters OK comex.orders OK comex.orders_products OK comex.orders_products_attributes OK comex.orders_products_download OK comex.orders_status OK comex.orders_status_history OK comex.orders_total OK comex.paypal_payment_status_history OK comex.paypal_session OK comex.product_music_extra OK comex.product_type_layout OK comex.product_types OK comex.product_types_to_category OK comex.products OK comex.products_attributes OK comex.products_attributes_download OK comex.products_description OK comex.products_discount_quantity OK comex.products_notifications OK comex.products_options OK comex.products_options_types OK comex.products_options_values OK comex.products_options_values_to_products_options OK comex.products_to_categories OK comex.project_version OK comex.project_version_history OK comex.query_builder OK comex.record_artists OK comex.record_artists_info OK comex.record_company OK comex.record_company_info OK comex.reviews OK comex.reviews_description OK comex.salemaker_sales OK comex.seo_cache OK comex.sessions OK comex.specials OK comex.tax_class OK comex.tax_rates OK comex.template_select OK comex.upgrade_exceptions OK comex.whats_new_info OK comex.whos_online OK comex.zones OK comex.zones_to_geo_zones OK comex_master.address_book OK comex_master.address_format OK comex_master.admin OK comex_master.admin_activity_log OK comex_master.authorizenet OK comex_master.banners OK comex_master.banners_history OK comex_master.blocks OK comex_master.categories OK comex_master.categories_description OK comex_master.configuration OK comex_master.configuration_group OK comex_master.counter OK comex_master.counter_history OK comex_master.countries OK comex_master.coupon_email_track OK comex_master.coupon_gv_customer OK comex_master.coupon_gv_queue OK comex_master.coupon_redeem_track OK comex_master.coupon_restrict OK comex_master.coupons OK comex_master.coupons_description OK comex_master.currencies OK comex_master.customers OK comex_master.customers_basket OK comex_master.customers_basket_attributes OK comex_master.customers_info OK comex_master.customers_wishlist OK comex_master.db_cache OK comex_master.email_archive OK comex_master.ezpages OK comex_master.featured OK comex_master.files_uploaded OK comex_master.geo_zones OK comex_master.get_terms_to_filter OK comex_master.group_pricing OK comex_master.languages OK comex_master.layout_boxes OK comex_master.manufacturers OK comex_master.manufacturers_info OK comex_master.media_clips OK comex_master.media_manager OK comex_master.media_to_products OK comex_master.media_types OK comex_master.meta_tags_categories_description OK comex_master.meta_tags_products_description OK comex_master.music_genre OK comex_master.newsletters OK comex_master.orders OK comex_master.orders_products OK comex_master.orders_products_attributes OK comex_master.orders_products_download OK comex_master.orders_status OK comex_master.orders_status_history OK comex_master.orders_total OK comex_master.paypal_payment_status_history OK comex_master.paypal_session OK comex_master.product_music_extra OK comex_master.product_type_layout OK comex_master.product_types OK comex_master.product_types_to_category OK comex_master.products OK comex_master.products_attributes OK comex_master.products_attributes_download OK comex_master.products_description OK comex_master.products_discount_quantity OK comex_master.products_notifications OK comex_master.products_options OK comex_master.products_options_types OK comex_master.products_options_values OK comex_master.products_options_values_to_products_options OK comex_master.products_to_categories OK comex_master.project_version OK comex_master.project_version_history OK comex_master.query_builder OK comex_master.record_artists OK comex_master.record_artists_info OK comex_master.record_company OK comex_master.record_company_info OK comex_master.reviews OK comex_master.reviews_description OK comex_master.salemaker_sales OK comex_master.seo_cache OK comex_master.sessions OK comex_master.specials OK comex_master.tax_class OK comex_master.tax_rates OK comex_master.template_select OK comex_master.upgrade_exceptions OK comex_master.whats_new_info OK comex_master.whos_online OK comex_master.zones OK comex_master.zones_to_geo_zones OK goodshop.wp_blc_filters OK goodshop.wp_blc_instances OK goodshop.wp_blc_links OK goodshop.wp_blc_synch OK goodshop.wp_commentmeta OK goodshop.wp_comments OK goodshop.wp_ktaisession OK goodshop.wp_links OK goodshop.wp_lockdowns OK goodshop.wp_login_fails OK goodshop.wp_options OK goodshop.wp_postmeta OK goodshop.wp_posts OK goodshop.wp_term_relationships OK goodshop.wp_term_taxonomy OK goodshop.wp_terms OK goodshop.wp_usermeta OK goodshop.wp_users OK iptablelog.host_cache OK iptablelog.ports OK iptablelog.protos OK iptablelog.ulog OK kaosuweb.blogn_access OK kaosuweb.blogn_categorygroup OK kaosuweb.blogn_categorylist OK kaosuweb.blogn_commentdata OK kaosuweb.blogn_commentlist OK kaosuweb.blogn_denyip OK kaosuweb.blogn_filelist OK kaosuweb.blogn_init OK kaosuweb.blogn_linkgroup OK kaosuweb.blogn_linklist OK kaosuweb.blogn_logdata OK kaosuweb.blogn_loglist OK kaosuweb.blogn_mod_archives_cache OK kaosuweb.blogn_mod_archives_init OK kaosuweb.blogn_mod_categorylist_cache OK kaosuweb.blogn_mod_linkslist_cache OK kaosuweb.blogn_mod_newentry_cache OK kaosuweb.blogn_mod_newentry_init OK kaosuweb.blogn_mod_profilelist_cache OK kaosuweb.blogn_mod_recomment_cache OK kaosuweb.blogn_mod_recomment_init OK kaosuweb.blogn_mod_retrackback_cache OK kaosuweb.blogn_mod_retrackback_init OK kaosuweb.blogn_module OK kaosuweb.blogn_pinglist OK kaosuweb.blogn_profile OK kaosuweb.blogn_skinlist OK kaosuweb.blogn_trackback OK kaosuweb.blogn_userlist OK kaosuweb.blogn_viewskin OK kaosuweb.blogn_viewskin_mobile 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 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 OK 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 error : Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it! 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 error : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" or dump/reload to fix it! mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK ranking.zzz_category OK ranking.zzz_cfg OK ranking.zzz_cfg_reg OK ranking.zzz_counter OK ranking.zzz_counter_log OK ranking.zzz_key OK ranking.zzz_key_rank OK ranking.zzz_log OK ranking.zzz_log_temp OK ranking.zzz_rank OK ranking.zzz_rank_counter OK ranking.zzz_report OK ranking.zzz_rev OK ranking.zzz_text OK yoimono.wp_blc_filters OK yoimono.wp_blc_instances OK yoimono.wp_blc_links OK yoimono.wp_blc_synch OK yoimono.wp_commentmeta OK yoimono.wp_comments OK yoimono.wp_ktaisession OK yoimono.wp_links OK yoimono.wp_lockdowns OK yoimono.wp_login_fails OK yoimono.wp_options OK yoimono.wp_postmeta OK yoimono.wp_posts OK yoimono.wp_term_relationships OK yoimono.wp_term_taxonomy OK yoimono.wp_terms OK yoimono.wp_usermeta OK yoimono.wp_users OK Repairing tables mysql.help_category OK mysql.help_keyword OK mysql.help_topic OK mysql.proc OK mysql.time_zone_name OK Running 'mysql_fix_privilege_tables'... OK
error : Table upgrade required. Please do “REPAIR TABLE ` の部分が
気になりますが時間がある時に調査するようにします
