【待反馈】mysql 重启后无法启动。。

应该是空间满了，
验证码无法显示，无法登陆宝塔，
就重启了一下。 可以登陆了。清楚了日志
但是mysql无法启动了。
报错如下：

1. 2024-04-10 10:01:55 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYFYvfAG' (Errcode: 28 - No space left on device)
   
2. 2024-04-10 10:04:11 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYo5lyIA' (Errcode: 28 - No space left on device)
   
3. 2024-04-10 10:11:49 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYBbmLVG' (Errcode: 28 - No space left on device)
   
4. 2024-04-10 11:15:40 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYyHW6Xm' (Errcode: 28 - No space left on device)
   
5. 2024-04-10 11:30:31 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYXF5dBi' (Errcode: 28 - No space left on device)
   
6. 2024-04-10 11:48:10 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYgx41IN' (Errcode: 28 - No space left on device)
   
7. 2024-04-10 13:08:56 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYNCfNaB' (Errcode: 28 - No space left on device)
   
8. 2024-04-10 13:13:49 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYW2eVui' (Errcode: 28 - No space left on device)
   
9. 2024-04-10 13:15:29 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYhKt59o' (Errcode: 28 - No space left on device)
   
10. 2024-04-10 13:24:32 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYGsgMro' (Errcode: 28 - No space left on device)
    
11. 2024-04-10 13:47:27 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYbevfPU' (Errcode: 28 - No space left on device)
    
12. 2024-04-10 14:09:46 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYYYnNBm' (Errcode: 28 - No space left on device)
    
13. 2024-04-10 14:41:04 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYvymbVs' (Errcode: 28 - No space left on device)
    
14. 2024-04-10 15:17:36 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYEX2PW2' (Errcode: 28 - No space left on device)
    
15. 2024-04-10 17:00:06 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYT9jxDh' (Errcode: 28 - No space left on device)
    
16. 2024-04-10 17:25:03 1881 [ERROR] /www/server/mysql/bin/mysqld: Sort aborted: Can't create/write to file '/tmp/MYeV2PRq' (Errcode: 28 - No space left on device)
    
17. 
    

复制代码

1. 
   

复制代码

就是空间满了的意思啊，清理一下空间

蓝易云 发表于 2024-4-11 11:24
就是空间满了的意思啊，清理一下空间

现在空间很多， 清理出来20G  
但是还提示这个。

18503592502 发表于 2024-4-11 11:25
现在空间很多， 清理出来20G  
但是还提示这个。

清理一下/tmp目录下的文件再去启动试试

运维技术南一 发表于 2024-4-11 11:56
清理一下/tmp目录下的文件再去启动试试

清理了，依旧不行。

18503592502 发表于 2024-4-11 12:24
清理了，依旧不行。

您是什么操作系统
还是无法解决的话建议备份一下数据，然后重新安装

运维技术南一 发表于 2024-4-11 16:58
您是什么操作系统
还是无法解决的话建议备份一下数据，然后重新安装

我也是这种情况无法启动怎么备份呢？

尝试下面方式，操作前做好服务器快照或备份

1. rm -f /www/server/data/ib_*
   
2. rm -f /www/server/data/mysql-bin*

复制代码

如仍无法启动，可能是数据库表损坏了，可以咨询一下专业的DBA