因MySQL的进程依然占用被删除的缓存文件,导致硬盘容量紧张
重启数据库后无法启动
root@cqhc:/home/debian# systemctl start mysqld.service Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xeu mysqld.service" for details.
root@cqhc:/home/debian# systemctl status mysqld.service × mysqld.service - LSB: start and stop MySQL Loaded: loaded (/etc/init.d/mysqld; generated) Active: failed (Result: exit-code) since Mon 2025-02-17 10:38:37 CST; 41s ago Docs: man:systemd-sysv-generator(8) Process: 31568 ExecStart=/etc/init.d/mysqld start (code=exited, status=1/FAILURE) CPU: 1.355s Feb 17 10:38:35 cqhc systemd[1]: Starting mysqld.service - LSB: start and stop MySQL... Feb 17 10:38:37 cqhc mysqld[31568]: Starting MySQL..The server quit without updating PID file (/www/server/data/cqhc.pid). ... failed! Feb 17 10:38:37 cqhc systemd[1]: mysqld.service: Control process exited, code=exited, status=1/FAILURE Feb 17 10:38:37 cqhc systemd[1]: mysqld.service: Failed with result 'exit-code'. Feb 17 10:38:37 cqhc systemd[1]: Failed to start mysqld.service - LSB: start and stop MySQL. Feb 17 10:38:37 cqhc systemd[1]: mysqld.service: Consumed 1.355s CPU time.
准备进行重装:
备份数据库目录,没有修改默认的情况目录为:/www/server/data,需要整体备份
删除数据库目录,rm -rf /www/server/mysql
正常重装(MySQL版本一致),装好后直接停止
复制备份目录(data)下的的数据库目录以及mysql.ibd、ibdata1
启动数据库,然后查看数据库是否正常读到数据库,密码默认是没有变化的