【已回应】mysql无法启动，尝试修复了一上午，还是没有成功

尝试用 sql-repair.sh 修复mysql，输出如下

# wget -O sql-repair.sh http://download.bt.cn/install/sql-repair.sh && sh sql-repair.sh
--2019-12-10 13:11:51--  http://download.bt.cn/install/sql-repair.sh
Resolving download.bt.cn... 119.147.144.34, 125.88.182.172, 240e:ff:9000:1100:0:3:0:35
Connecting to download.bt.cn|119.147.144.34|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 19399 (19K) [application/octet-stream]
Saving to: “sql-repair.sh”

100%[======================================================================================================================>] 19,399      --.-K/s   in 0.03s

2019-12-10 13:11:51 (596 KB/s) - “sql-repair.sh” saved [19399/19399]

du: cannot access `/www/server/data/mysql-bin.*': No such file or directory
ERROR! MySQL server PID file could not be found!
mv: cannot stat `/www/server/data/mysql-bin.*': No such file or directory
Starting MySQL.... ERROR! The server quit without updating PID file (/www/server/data/iZ237fi5137Z.pid).
==========================================================================================
2019-12-10T05:11:52.736683Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2019-12-10T05:11:54.014035Z 0 [ERROR] InnoDB: Cannot open '/www/server/data/ib_buffer_pool' for reading: No such file or directory
2019-12-10T05:11:54.055448Z 0 [ERROR] Unix socket lock file is empty /tmp/mysql.sock.lock.
2019-12-10T05:11:54.055460Z 0 [ERROR] Unable to setup unix socket lock file.
2019-12-10T05:11:54.055475Z 0 [ERROR] Aborting
==========================================================================================
mysql start error.
mysql无法正常启动，请将以上错误信息截图发至论坛寻求帮助

2019-12-10T05:28:00.244386Z 0 [ERROR] Unix socket lock file is empty /tmp/mysql.sock.lock.
2019-12-10T05:28:00.244397Z 0 [ERROR] Unable to setup unix socket lock file.
2019-12-10T05:28:00.244411Z 0 [ERROR] Aborting

一个奇怪的问题，重启服务器后mysql无法自动启动
面板上也无法启动成功
现在只能通过 wget -O sql-repair.sh http://download.bt.cn/install/sql-repair.sh && sh sql-repair.sh 启动数据库

求救！

tsuibin 发表于 2019-12-10 14:07
一个奇怪的问题，重启服务器后mysql无法自动启动
面板上也无法启动成功
现在只能通过 wget -O sql-repair.s ...

加一下我qq：977100966，记得备注问题，不备注不添加，帮您看看。

磁盘空间满了导致启动MySQL失败，清理后正常启动。

用脚本把mysql跑起来之后，重新安装了mysql；
之前确实是没注意导致磁盘跑满，然后mysql意外挂了。