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

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文件就可以进行备份数据库了

相关标签：

本文原创发布php中文网，转载请注明出处，感谢您的尊重！