MySQL 报错!该怎么解决

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吧




我也遇到类似的问题 问老师 老师也没有给我解决

MySQL 报错!该怎么解决

相关文章:

你感兴趣的文章:

标签云: