今天在备份数据库的时候出现如标题的错误，不能备份数据。于是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文件就可以进行备份数据库了
Copyright © 2019-2025 51dongshi.net 版权所有
违法及侵权请联系：TEL:177 7030 7066 E-MAIL:11247931@qq.com 本站由北京市万商天勤律师事务所王兴未律师提供法律服务
