当前位置:Gxlcms > mysql > navicat备份mysql报错1548cannotloadmysql.proc_MySQL

navicat备份mysql报错1548cannotloadmysql.proc_MySQL

时间:2021-07-01 10:21:17 帮助过:9人阅读

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,里面的内容为升级后的数据库版本。

然后再次运行,备份数据库的,转储sql文件就可以进行备份数据库了

人气教程排行