mysql入坑之路（9）Navicat导出SQL数据报错1577 - Cannot proceed because system tables used by Event Scheduler were...

最新推荐文章于 2024-10-13 21:08:42 发布

muzlei

最新推荐文章于 2024-10-13 21:08:42 发布

阅读量900

点赞数

文章标签： mysql sql 数据库 sqlserver

本文链接：https://blog.csdn.net/A___LEi/article/details/127661423

版权

参考文档：https://codeantenna.com/a/mPlevmGxeA<==参考文档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数据库