MySQL:TIPS:DBのバージョンアップ方法
提供：KinusatiWiki
バージョンアップする場合
新規バージョンで上書きインストールしデーモンを起動後、以下コマンドを実行します。
# mysql_upgrade -uroot -p
実行結果例
# /usr/local/mysql/bin/mysql_upgrade -uroot -p Enter password: Looking for 'mysql' as: /usr/local/mysql/bin/mysql Looking for 'mysqlcheck' as: /usr/local/mysql/bin/mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock' cacti.cdef OK cacti.cdef_items OK cacti.colors OK cacti.data_input OK cacti.data_input_data OK cacti.data_input_fields OK cacti.data_local OK cacti.data_template OK cacti.data_template_data OK cacti.data_template_data_rra OK cacti.data_template_rrd OK cacti.graph_local OK cacti.graph_template_input OK cacti.graph_template_input_defs OK cacti.graph_templates OK cacti.graph_templates_gprint OK cacti.graph_templates_graph OK cacti.graph_templates_item OK cacti.graph_tree OK cacti.graph_tree_items OK cacti.host OK cacti.host_graph OK cacti.host_snmp_cache OK cacti.host_snmp_query OK cacti.host_template OK cacti.host_template_graph OK cacti.host_template_snmp_query OK cacti.poller OK cacti.poller_command OK cacti.poller_item OK cacti.poller_output OK cacti.poller_reindex OK cacti.poller_time OK cacti.rra OK cacti.rra_cf OK cacti.settings OK cacti.settings_graphs OK cacti.settings_tree OK cacti.snmp_query OK cacti.snmp_query_graph OK cacti.snmp_query_graph_rrd OK cacti.snmp_query_graph_rrd_sv OK cacti.snmp_query_graph_sv OK cacti.user_auth OK cacti.user_auth_perms OK cacti.user_auth_realm OK cacti.user_log OK cacti.version 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 redmine.attachments OK redmine.auth_sources OK redmine.boards OK redmine.changes OK redmine.changesets OK redmine.changesets_issues OK redmine.comments OK redmine.custom_fields OK redmine.custom_fields_projects OK redmine.custom_fields_trackers OK redmine.custom_values OK redmine.documents OK redmine.enabled_modules OK redmine.enumerations OK redmine.groups_users OK redmine.issue_categories OK redmine.issue_relations OK redmine.issue_statuses OK redmine.issues OK redmine.journal_details OK redmine.journals OK redmine.member_roles OK redmine.members OK redmine.messages OK redmine.news OK redmine.open_id_authentication_associations OK redmine.open_id_authentication_nonces OK redmine.plugin_schema_info OK redmine.projects OK redmine.projects_trackers OK redmine.queries OK redmine.repositories OK redmine.roles OK redmine.schema_migrations OK redmine.settings OK redmine.time_entries OK redmine.tokens OK redmine.trackers OK redmine.user_preferences OK redmine.users OK redmine.versions OK redmine.watchers OK redmine.wiki_content_versions OK redmine.wiki_contents OK redmine.wiki_pages OK redmine.wiki_redirects OK redmine.wikis OK redmine.workflows OK Running 'mysql_fix_privilege_tables'... OK
