今天在备份数据库的时候出现如标题的错误,不能备份数据。于是google一下显示。(我采用的数据库管理工具为:Navicat Premium)
找到了解决方法:执行以下命令
      #mysql_upgrade -u root -p
      #Enter password: (输入密码)
输入密码后会显示:
[root@AY130701184903434d7bZ usr]# mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
b3log.b3_solo_archiveDate OK
b3log.b3_solo_archiveDate_article OK
b3log.b3_solo_archiveDate_copy OK
b3log.b3_solo_article OK
b3log.b3_solo_comment OK
b3log.b3_solo_link OK
b3log.b3_solo_option OK
b3log.b3_solo_page OK
b3log.b3_solo_plugin OK
b3log.b3_solo_preference OK
b3log.b3_solo_statistic OK
b3log.b3_solo_tag OK
b3log.b3_solo_tag_article OK
b3log.b3_solo_user OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Running 'mysql_fix_privilege_tables'...
OK
此命令会在数据目录下生成一个文本文件mysql_upgrade_info,里面的内容为升级后的数据库版本。
然后再次运行,备份数据库的,转储sql文件就可以进行备份数据库了