goback add

MySQL,4.0升级到5.1遇到一个问题

2480 点击·0 回帖
灯火互联
楼主

数据库数据量暴增,对比其他业务类似的数据库发现某个表的数据量异常,最后确定了一个重复迁移数据的bug...


120301 17:30:43 [ERROR] Column count of mysql.db is wrong. Expected 22, found 15. The table is probably corrupted
120301 17:30:43 [ERROR] mysql.user has no `Event_priv` column at position 29
120301 17:30:43 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.


4.0升级5.1 SA工程师在写自动脚本shi忘记./bin/mysql_upgrade  -u root -p --sock=/tmp/mysql5.sock了

喜欢0 评分0