VPS侦探论坛

 找回密码
 注册
搜索
热搜: pathinfo
查看: 1044|回复: 3

mysql启动不了,提示he server quit without updating PID file (/usr/local/mysql/var/iZuf6

[复制链接]
发表于 2017-11-27 12:56:02 | 显示全部楼层 |阅读模式



171127 12:28:02 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
171127 12:28:02 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 4071 ...
171127 12:28:02 [Note] Plugin 'FEDERATED' is disabled.
171127 12:28:02 InnoDB: The InnoDB memory heap is disabled
171127 12:28:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171127 12:28:02 InnoDB: Compressed tables use zlib 1.2.7
171127 12:28:02 InnoDB: Initializing buffer pool, size = 16.0M
171127 12:28:02 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
171127 12:28:02  InnoDB: Retrying to lock the first data file
InnoDB: Error: checksum mismatch in data file /usr/local/mysql/var/ibdata1
171127 12:28:03 InnoDB: Could not open or create data files.
171127 12:28:03 InnoDB: If you tried to add new data files, and it failed here,
171127 12:28:03 InnoDB: you should now edit innodb_data_file_path in my.cnf back
171127 12:28:03 InnoDB: to what it was, and remove the new ibdata files InnoDB created
171127 12:28:03 InnoDB: in this failed attempt. InnoDB only wrote those files full of
171127 12:28:03 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
171127 12:28:03 InnoDB: remove old data files which contain your precious data!
171127 12:28:03 [ERROR] Plugin 'InnoDB' init function returned error.
171127 12:28:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
171127 12:28:03 [ERROR] Unknown/unsupported storage engine: InnoDB
171127 12:28:03 [ERROR] Aborting

171127 12:28:03 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

171127 12:28:03 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZuf63mxkrdvotr78sx34mZ.pid ended
171127 12:29:25 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
171127 12:29:25 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 5631 ...
171127 12:29:25 [Note] Plugin 'FEDERATED' is disabled.
171127 12:29:25 InnoDB: The InnoDB memory heap is disabled
171127 12:29:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins


171127 12:29:25 InnoDB: Compressed tables use zlib 1.2.7
171127 12:29:25 InnoDB: Initializing buffer pool, size = 16.0M
171127 12:29:25 InnoDB: Completed initialization of buffer pool
InnoDB: Error: checksum mismatch in data file /usr/local/mysql/var/ibdata1
171127 12:29:25 InnoDB: Could not open or create data files.
171127 12:29:25 InnoDB: If you tried to add new data files, and it failed here,
171127 12:29:25 InnoDB: you should now edit innodb_data_file_path in my.cnf back
171127 12:29:25 InnoDB: to what it was, and remove the new ibdata files InnoDB created
171127 12:29:25 InnoDB: in this failed attempt. InnoDB only wrote those files full of
171127 12:29:25 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
171127 12:29:25 InnoDB: remove old data files which contain your precious data!
171127 12:29:25 [ERROR] Plugin 'InnoDB' init function returned error.
171127 12:29:25 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
171127 12:29:25 [ERROR] Unknown/unsupported storage engine: InnoDB
171127 12:29:25 [ERROR] Aborting

171127 12:29:25 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

171127 12:29:25 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZuf63mxkrdvotr78sx34mZ.pid ended
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org/
 楼主| 发表于 2017-11-27 12:58:01 | 显示全部楼层

大神来吧
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2017-11-28 10:39:05 | 显示全部楼层


之前做过什么操作?
提前备份好数据库目录到其他目录下!!!!!!!!!
然后删除数据库目录下的ib_logfile ib_logfile0 ib_logfile1 ibdata1  这几个文件,然后重启试试
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2017-11-28 15:12:24 | 显示全部楼层


ok

美国VPS、VPN、域名代购:http://shop63846532.taobao.com/

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2019-4-25 21:00 , Processed in 0.045383 second(s), 26 queries .

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表