解决用Navicat备份导出mysql数据库的时候出现 “Cannot proceed because system tables used by Event Scheduler were found damaged at server start” 错误

2011-12-23 20:48:53 作者：linuxzgf 来源：运维之家 浏览次数：0 网友评论 0 条

解决用Navicat备份导出mysql数据库的时候出现 “Cannot proceed because system tables used by Event Scheduler were found damaged at server start” 错误

原创作品  作者：linuxzgf  原文链接：http://www.f5ha.com/2011/1223/xNMDAwMDAwMDYxNg.html
转载请注明：运维之家/运维家园
欢迎大家转载运维之家/运维家园文章到自己的网站/博客/微博，请勿修改原文内容，谢谢！

错误描述：
用Navicat备份导出mysql数据库的时候出现 “Cannot proceed because system tables used by Event Scheduler were found damaged at server start” 错误
错误原因：
MySQL服务器的当前版本不兼容所有数据库的表

解决步骤方法：
[root@f5ha.com ~]# /usr/local/mysql/bin/mysql_upgrade - u root -p  #根据路径不一样来写此句
[root@f5ha.com ~]# /usr/local/mysql/bin/mysql_upgrade - u root -p
Enter password:
Looking for 'mysql' as: /usr/local/mysql/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/mysql/bin/mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
a03_forum.jforum_api                               OK
a03_forum.jforum_attach                            OK
a03_forum.jforum_attach_desc                       OK
a03_forum.jforum_attach_quota                      OK
a03_forum.jforum_banlist                           OK
a03_forum.jforum_banner                            OK
a03_forum.jforum_bookmarks                         OK
a03_forum.jforum_categories                        OK
a03_forum.jforum_config                            OK
a03_forum.jforum_extension_groups                  OK
a03_forum.jforum_extensions                        OK
a03_forum.jforum_forums                            OK
a03_forum.jforum_forums_watch                      OK
a03_forum.jforum_groups                            OK
a03_forum.jforum_karma                             OK
a03_forum.jforum_mail_integration                  OK
a03_forum.jforum_moderation_log                    OK
a03_forum.jforum_posts                             OK
a03_forum.jforum_posts_text                        OK
a03_forum.jforum_privmsgs                          OK
a03_forum.jforum_privmsgs_text                     OK
a03_forum.jforum_quota_limit                       OK
a03_forum.jforum_ranks                             OK
a03_forum.jforum_role_values                       OK
a03_forum.jforum_roles                             OK
a03_forum.jforum_sessions                          OK
a03_forum.jforum_smilies                           OK
a03_forum.jforum_themes                            OK
a03_forum.jforum_topics                            OK
a03_forum.jforum_topics_watch                      OK
a03_forum.jforum_user_groups                       OK
a03_forum.jforum_users                             OK
a03_forum.jforum_vote_desc                         OK
a03_forum.jforum_vote_results                      OK
a03_forum.jforum_vote_voters                       OK
a03_forum.jforum_words                             OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.func                                         OK
mysql.help_category
error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it!
mysql.help_keyword
error    : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" or dump/reload to fix it!
mysql.help_relation                                OK
mysql.help_topic
error    : Table upgrade required. Please do "REPAIR TABLE `help_topic`" or dump/reload to fix it!
mysql.host                                         OK
mysql.proc
error    : Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it!
mysql.procs_priv                                   OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name
error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" or dump/reload to fix it!
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK

Repairing tables
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_topic                                   OK
mysql.proc                                         OK
mysql.time_zone_name                               OK
Running 'mysql_fix_privilege_tables'...
OK

执行后重启下
执行完后停止mysqld后再重新启动mysqld
[root@f5ha.com ~]# /etc/init.d/mysql restart                    
Shutting down MySQL.                                       [  OK  ]
Starting MySQL.                                            [  OK  ]

再次执行即可成功。