MySQL 报错！！
启动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




------解决方案--------------------
MYSQL什么版本，安装 OR 绿色？数据是COPY？MYSQL服务没有启动？
------解决方案--------------------
检查一下ibdata1文件，好像出了问题。
你可以把ibdata1和iblog文件备份后移走，再看MYSQL是否能启动。
------解决方案--------------------
111219 18:07:07 [ERROR] Unknown/unsupported table type: INNOD



删掉ibdata1 ib_logfile0 ib_logfile1文件 

重启service mysql restart
------解决方案--------------------
估计是丢失文件了，或者文件损坏了，lz你还是重装mysql吧
------解决方案--------------------
我也遇到类似的问题 问老师 老师也没有给我解决