【待反馈】数据库更新

数据库更新成功了，但是运行异常，能否退回更新
或者有什么更好的处理办法

您好，这个是无法回退的，更新会直接将以往程序源码覆盖的，您那边执行下面命令看下MySQL日志

1. cat /www/server/data/*.err | grep -i -C 10 error

复制代码

1. root@iz2ze4m2ri7irk7g9t31e4z ~]# cat /www/server/data/*.err | grep -i -C 10 error
   
2. 2021-09-07 14:02:37 1932 [Note] InnoDB: Database was not shutdown normally!
   
3. 2021-09-07 14:02:37 1932 [Note] InnoDB: Starting crash recovery.
   
4. 2021-09-07 14:02:37 1932 [Note] InnoDB: Reading tablespace information from the .ibd files...
   
5. 2021-09-07 14:02:44 1932 [Note] InnoDB: Restoring possible half-written data pages
   
6. 2021-09-07 14:02:44 1932 [Note] InnoDB: from the doublewrite buffer...
   
7. InnoDB: Last MySQL binlog file position 0 20813352, file name mysql-bin.000057
   
8. 2021-09-07 14:02:44 1932 [Note] InnoDB: 128 rollback segment(s) are active.
   
9. 2021-09-07 14:02:44 1932 [Note] InnoDB: Waiting for purge to start
   
10. 2021-09-07 14:02:44 1932 [Note] InnoDB: 5.6.45 started; log sequence number 4519357589
    
11. 2021-09-07 14:02:44 1932 [Note] Recovering after a crash using mysql-bin
    
12. 2021-09-07 14:02:44 1932 [ERROR] Error in Log_event::read_log_event(): 'Event too small', data_len: 0, event_type: 0
    
13. 2021-09-07 14:02:44 1932 [Note] Starting crash recovery...
    
14. 2021-09-07 14:02:44 1932 [Note] Crash recovery finished.
    
15. 2021-09-07 14:02:44 1932 [Note] Crashed binlog file ./mysql-bin.000057 size is 20813352, but recovered up to 20812846. Binlog trimmed to 20812846 bytes.
    
16. 2021-09-07 14:02:44 1932 [Note] Server hostname (bind-address): '*'; port: 3306
    
17. 2021-09-07 14:02:44 1932 [Note] IPv6 is available.
    
18. 2021-09-07 14:02:44 1932 [Note]   - '::' resolves to '::';
    
19. 2021-09-07 14:02:44 1932 [Note] Server socket created on IP: '::'.
    
20. 2021-09-07 14:02:45 1932 [Note] Event Scheduler: Loaded 0 events
    
21. 2021-09-07 14:02:45 1932 [Note] /www/server/mysql/bin/mysqld: ready for connections.
    
22. Version: '5.6.45-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
    
23. [root@iz2ze4m2ri7irk7g9t31e4z ~]#

复制代码

出现这个错误 不知道什么原因 现在不知道如何快速处理 请大神指点

可不可以把别的站点的  MySQL 5.6.50  放在这个站点的  /www/server/mysql  目录下

谢花郎 发表于 2022-8-20 15:16
您好，这个是无法回退的，更新会直接将以往程序源码覆盖的，您那边执行下面命令看下MySQL日志

...

可不可以把别的站点的  MySQL 5.6.50  放在这个站点的  /www/server/mysql  目录下

宝塔用户_oezjgo 发表于 2022-8-20 15:33
可不可以把别的站点的  MySQL 5.6.50  放在这个站点的  /www/server/mysql  目录下

不能，你提供的日志是2021年的了，我需要最新日志