navicat 备份 mysql 报错 1548 cannot load mysql.proc

navicat 备份 mysql 报错 1548 cannot load mysql.proc_MySQL

WBOY

发布： 2016-06-01 13:11:25

原创

2122 人浏览过

Navicat

今天在备份数据库的时候出现如标题的错误，不能备份数据。于是google一下显示。（我采用的数据库管理工具为：Navicat Premium）

找到了解决方法：执行以下命令

#mysql_upgrade -u root -p

#Enter password: （输入密码）

输入密码后会显示：

[root@AY130701184903434d7bZ usr]# mysql_upgrade -u root -pEnter password:Looking for 'mysql' as: mysqlLooking for 'mysqlcheck' as: mysqlcheckRunning 'mysqlcheck with default connection argumentsRunning 'mysqlcheck with default connection argumentsb3log.b3_solo_archiveDate                          OKb3log.b3_solo_archiveDate_article                  OKb3log.b3_solo_archiveDate_copy                     OKb3log.b3_solo_article                              OKb3log.b3_solo_comment                              OKb3log.b3_solo_link                                 OKb3log.b3_solo_option                               OKb3log.b3_solo_page                                 OKb3log.b3_solo_plugin                               OKb3log.b3_solo_preference                           OKb3log.b3_solo_statistic                            OKb3log.b3_solo_tag                                  OKb3log.b3_solo_tag_article                          OKb3log.b3_solo_user                                 OKmysql.columns_priv                                 OKmysql.db                                           OKmysql.event                                        OKmysql.func                                         OKmysql.general_log                                  OKmysql.help_category                                OKmysql.help_keyword                                 OKmysql.help_relation                                OKmysql.help_topic                                   OKmysql.host                                         OKmysql.ndb_binlog_index                             OKmysql.plugin                                       OKmysql.proc                                         OKmysql.procs_priv                                   OKmysql.servers                                      OKmysql.slow_log                                     OKmysql.tables_priv                                  OKmysql.time_zone                                    OKmysql.time_zone_leap_second                        OKmysql.time_zone_name                               OKmysql.time_zone_transition                         OKmysql.time_zone_transition_type                    OKmysql.user                                         OKRunning 'mysql_fix_privilege_tables'...OK

登录后复制

此命令会在数据目录下生成一个文本文件mysql_upgrade_info，里面的内容为升级后的数据库版本。