+ -
当前位置:首页 → 问答吧 → MySQL 报错!!

MySQL 报错!!

时间:2011-12-20

来源:互联网

启动mysql 报错:

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

socket=/var/run/mysql/mysql.sock 下没有 mysql.sock  




error.log:

111219 18:07:07 [Note] Plugin 'FEDERATED' is disabled.
111219 18:07:07 InnoDB: Started; log sequence number 0 512283174
111219 18:07:07 [ERROR] Unknown/unsupported table type: INNOD
111219 18:07:07 [ERROR] Aborting

111219 18:07:07 InnoDB: Starting shutdown...
111219 18:07:13 InnoDB: Shutdown completed; log sequence number 0 512283174
111219 18:07:13 [Note] /usr/sbin/mysqld: Shutdown complete

111220 8:42:03 [Note] Plugin 'FEDERATED' is disabled.
111220 8:42:06 InnoDB: Started; log sequence number 0 512283174
111220 8:42:06 [ERROR] Unknown/unsupported table type: INNOD
111220 8:42:06 [ERROR] Aborting

111220 8:42:06 InnoDB: Starting shutdown...
111220 8:42:11 InnoDB: Shutdown completed; log sequence number 0 512283174
111220 8:42:12 [Note] /usr/sbin/mysqld: Shutdown complete

111220 8:42:34 [Note] Plugin 'FEDERATED' is disabled.
111220 8:42:35 InnoDB: Started; log sequence number 0 512283174
111220 8:42:35 [ERROR] Unknown/unsupported table type: INNOD
111220 8:42:35 [ERROR] Aborting

111220 8:42:35 InnoDB: Starting shutdown...
111220 8:42:36 InnoDB: Shutdown completed; log sequence number 0 512283174
111220 8:42:36 [Note] /usr/sbin/mysqld: Shutdown complete


作者: yq510457   发布时间: 2011-12-20

网上找了好多方法没解决

作者: yq510457   发布时间: 2011-12-20

MYSQL什么版本,安装 OR 绿色?数据是COPY?MYSQL服务没有启动?

作者: wwwwb   发布时间: 2011-12-20

安装的版本是 5.1.11 

MYSQL服务启动不起来  


平时正常关机没出问题,突然断电重启会出现。

作者: yq510457   发布时间: 2011-12-20

检查一下ibdata1文件,好像出了问题。
你可以把ibdata1和iblog文件备份后移走,再看MYSQL是否能启动。

作者: ACMAIN_CHM   发布时间: 2011-12-20