Cannot proceed because system tables used by Event Scheduler were found damaged at server start
Cannot proceed because system tables used by Event Scheduler were found damaged at server start
今天因测试库出现了一点问题，怀疑某些人误操作对数据库进行了升级
在navicat 上面 导出表报错，[ERR] 1577 – Cannot proceed because system tables used by Event Scheduler were found damaged at server start、
今天在MySQL 5.7的数据库上导出数据库时，碰到一个错误信息：Cannot proceed because system tables used by Event Scheduler were found damaged at server start；最近对数据库进行了升级，可能是因为数据库版本不一致造成的，网上找的解决方法，记录一下。
找到mysql/bin目录 ，依次执行如下命令（xxxxxxxxxx为数据库root用户的密码）：
mysqlcheck是用来 检查，分析，优化，修复表的。
mysqlcheck -uroot -pxxxxxxxxxx --all-databases --check-upgrade --auto-repair再执行第2条命令
mysql_upgrade 检查所有数据库中与mysql服务器当前版本不兼容的所有表，mysql_upgrade也会升级系统表，以便你能使用新添加的权限或功能。如果mysql_upgrade发现一张表可能不兼容，将该表进行检查，如果发现问题，则试图对其进行修复。如果不能修复，则需要人工进行表和索引的重建或修复。每次升级mysql，都需要运行mysql_upgrade
mysql_upgrade -uroot -pxxxxxxxxxx --force如果还是报错，重启mysql服务。
service mysqld restartThe post Cannot proceed because system tables used by Event Scheduler were found damaged at server start first appeared on Linux迷.
共有 0 条评论