VPS侦探论坛

标题: LNMP 1.3版本 安装完成后MySQL启动失败 [打印本页]

作者: anxQ    时间: 2017-5-11 14:06
标题: LNMP 1.3版本 安装完成后MySQL启动失败
[attach]4225[/attach][root@iZ2zefbxvqr66xfmk0zzpmZ /]# service mysqld restart
MySQL server PID file could not be found!                  [FAILED]
Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql/var/iZ2zefbxvqr66xfmk0zzpmZ.pid).
作者: anxQ    时间: 2017-5-11 14:10
阿里云服务器
CentOS 6.8 x64
作者: licess    时间: 2017-5-11 19:44
df -h 看一下数据库所在磁盘是不是满了

InnoDB: Error: space header page consists of zero bytes in data file /usr/local/mysql/var/ibdata1
170511 12:47:31 InnoDB: Could not open or create data files.
170511 12:47:31 InnoDB: If you tried to add new data files, and it failed here,
170511 12:47:31 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170511 12:47:31 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170511 12:47:31 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170511 12:47:31 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170511 12:47:31 InnoDB: remove old data files which contain your precious data!
170511 12:47:31 [ERROR] Plugin 'InnoDB' init function returned error.
170511 12:47:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170511 12:47:31 [ERROR] Unknown/unsupported storage engine: InnoDB
170511 12:47:31 [ERROR] Aborting

看日志ibdata1可能损坏




欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/) Powered by Discuz! X3.4