mysql_upgrade

ubuntuer

mysql_upgrade

 

昨天因?yàn)?/span>innodb大量AUTO-INC LOCK 導(dǎo)致的DeadLOCK，升級(jí)mysql到5.1后一切正常，但是今早發(fā)現(xiàn)Tencent.err mysql錯(cuò)誤文件中有些錯(cuò)誤日志

….

/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官方文檔后發(fā)現(xiàn)，如果升級(jí)了需要運(yùn)行下mysql_update

mysql_upgrade -uxx –pxxx  -v

這里-v只是為了多輸出一些信息

 

 

實(shí)際運(yùn)行過(guò)程中

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!

 

 

出現(xiàn)了一些error，按照提示為進(jìn)行REPAIR TABLE `xxx`后問(wèn)題得到解決