首页 > 文章 > 数据库 > Mysql > 正文

Cannot proceed because system tables used by Event Scheduler were found
2011-12-23 20:44:06   来源:   评论:0 点击:

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

解决用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  ]

再次执行即可成功。
 

相关热词搜索:Cannot proceed because system tables

上一篇:linux下查看nginx,apache,mysql,php的编译参数[转]
下一篇:最后一页

分享到: 收藏
频道总排行
频道本月排行