当前位置:论坛首页 > Linux面板 > 求助

mysql5.6无法启动,请管理大大急救

发表在 Linux面板2017-9-11 17:36 [复制链接] 1 1718


ERROR! MySQL server PID file could not be found!
mv: cannot stat ‘/www/server/data/ib_*’: No such file or directory
Starting MySQL.. ERROR! The server quit without updating PID file (/www/server/data/XnMQaB38720.pid).
==========================================================================================
2017-09-11 17:29:01 3726 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-09-11 17:29:01 3726 [ERROR] InnoDB: auto-extending data file /www/server/data/ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 640 pages, max 0 (relevant if non-zero) pages!
2017-09-11 17:29:01 3726 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2017-09-11 17:29:01 3726 [ERROR] Plugin 'InnoDB' init function returned error.
2017-09-11 17:29:01 3726 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-09-11 17:29:01 3726 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-09-11 17:29:01 3726 [ERROR] Aborting
2017-09-11 17:29:58 4388 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-09-11 17:29:58 4388 [ERROR] InnoDB: auto-extending data file /www/server/data/ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 640 pages, max 0 (relevant if non-zero) pages!
2017-09-11 17:29:58 4388 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2017-09-11 17:29:58 4388 [ERROR] Plugin 'InnoDB' init function returned error.
2017-09-11 17:29:58 4388 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-09-11 17:29:58 4388 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-09-11 17:29:58 4388 [ERROR] Aborting
2017-09-12 01:30:47 3012 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-09-12 01:30:47 3012 [ERROR] InnoDB: auto-extending data file /www/server/data/ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 640 pages, max 0 (relevant if non-zero) pages!
2017-09-12 01:30:47 3012 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2017-09-12 01:30:47 3012 [ERROR] Plugin 'InnoDB' init function returned error.
2017-09-12 01:30:47 3012 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-09-12 01:30:47 3012 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-09-12 01:30:47 3012 [ERROR] Aborting
2017-09-12 01:34:05 11235 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-09-12 01:34:06 11235 [ERROR] InnoDB: auto-extending data file /www/server/data/ibdata1 is of a different size 0 pages (rounded down to MB) than specified in the .cnf file: initial 640 pages, max 0 (relevant if non-zero) pages!
2017-09-12 01:34:06 11235 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2017-09-12 01:34:06 11235 [ERROR] Plugin 'InnoDB' init function returned error.
2017-09-12 01:34:06 11235 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-09-12 01:34:06 11235 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-09-12 01:34:06 11235 [ERROR] Aborting
==========================================================================================
mysql start error.
mysql无法正常启动,请将以上错误信息截图发至论坛寻求帮助

用这个工具也无法修复启动
https://www.bt.cn/bbs/forum.php? ... tid=6109&extra=


使用道具 举报 只看该作者 回复
发表于 2017-9-11 18:48:50 | 显示全部楼层
已经解决了,是硬盘满了
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

普通问题处理

论坛响应时间:72小时

问题处理方式:排队(仅解答)

工作时间:白班:9:00 - 18:00

紧急运维服务

响应时间:3分钟

问题处理方式:宝塔专家1对1服务

工作时间:工作日:9:00 - 18:30

宝塔专业团队为您解决服务器疑难问题

点击联系技术免费分析

工作时间:09:00至18:30

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