此时多出来一个文件 general_log.CSM
[root@upgrade-slave mysql]# ll general_log.*
-rw-rw----. 1 mysql mysql 35 Dec 15 00:22 general_log.CSM
-rw-rw----. 1 mysql mysql 0 Dec 15 00:18 general_log.CSV
-rw-------. 1 mysql mysql 8776 Dec 15 00:22 general_log.frm
[root@upgrade-slave mysql]#
再次尝试升级
[root@upgrade-slave ~]# time mysql_upgrade -u root -p
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'
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log 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
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
azheng_db.answers OK
azheng_db.feedbacks OK
azheng_db.logged_exceptions OK
azheng_db.question_answers OK
azheng_db.questions OK
azheng_db.rule_answers OK
...
...
text_db.categories OK
text_db.exception_logger_logged_exceptions OK
text_db.missions OK
text_db.schema_migrations OK
text_db.taggings OK
text_db.tags OK
text_db.users OK
OK
real 0m59.267s
user 0m0.098s
sys 0m0.099s
[root@upgrade-slave ~]#
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。