参考文档:
https://blog.csdn.net/phpfenghuo/article/details/40537477
报错信息
[DTF] 0> Getting events
[ERR] 0> 1577 - Cannot proceed because system tables used by Event Scheduler were found damaged at server start
[DTF] Process terminated
naivcat客户端报错:
命令行查看报错:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| bpmx |
| imsrun |
| mick3310 |
| mysql |
| performance_schema |
| plancp |
| project_manage |
+--------------------+
8 rows in set (0.00 sec)
mysql> use bpmx;
Database changed
mysql> show events;
ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start
mysql> show variables like 'event_scheduler';
+-----------------+----------+
| Variable_name | Value |
+-----------------+----------+
| event_scheduler | DISABLED |
+-----------------+----------+
1 row in set (0.00 sec)
mysql> select * from mysql.event;
Empty set (0.00 sec)
解决:
原数据库的表版本和现在的数据库版本不一致造成的,需要更新下系统表结构
是现在要导出来的这个表结构和数据库的版本不适配
https://blog.csdn.net/zhh763984017/article/details/107082142/你打开下这个博客
1、启动mysql
mysqld_safe --defaults-file=/old-root/var/lib/mysql4/my.cnf &
2、进入mysql
mysql -uroot -pisunland -S /old-root/var/lib/mysql4/mysql.sock
3、执行mysql_upgrade 语句
/usr/mysql-5.7/bin/mysql_upgrade -uroot -pisunland -S /old-root/var/lib/mysql5/mysql.sock
4、重启mysql5数据库
标签:tables,because,报错,Scheduler,mysql,Event
From: https://www.cnblogs.com/muzlei/p/16707577.html