mysql_upgrade
昨天因为innodb大量AUTO-INC
LOCK 导致的DeadLOCK,升级mysql到5.1后一切正常,但是今早发现Tencent.err
mysql错误文件中有些错误日志
….
/usr/sbin/mysqld:
Table 'mysql.plugin' doesn't exist
110318
17:50:37 [ERROR] mysql.user has no `Event_priv` column at position 29
….
查阅mysql官方文档后发现,如果升级了需要运行下mysql_update
mysql_upgrade
-uxx –pxxx -v
这里-v只是为了多输出一些信息
实际运行过程中
db_svr_monitor.t_svr_alarm_record OK
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.help_category
error : Table upgrade required. Please do
"REPAIR TABLE `help_category`" to fix it!
mysql.help_keyword
error : Table upgrade required. Please do
"REPAIR TABLE `help_keyword`" to fix it!
mysql.help_relation OK
mysql.help_topic
error : Table upgrade required. Please do
"REPAIR TABLE `help_topic`" to fix it!
mysql.host OK
mysql.proc
error : Table upgrade required. Please do
"REPAIR TABLE `proc`" to fix it!
出现了一些error,按照提示为进行REPAIR
TABLE `xxx`后问题得到解决 |