启动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] Aborting111219 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 complete111220 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] Aborting111220 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 complete111220 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] Aborting111220 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
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] Aborting111219 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 complete111220 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] Aborting111220 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 complete111220 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] Aborting111220 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命令行查询时,中文字段不显示
- MYSQL集群(MYSQL簇)的NDB引擎,数据是保存在内存中吗?那如果整个机房停电了,数据会丢失吗?
- 我们写了一个sqlserver的分页存储过程,但是怎么样按照这种的根式,写一个mysql的分页存储过程!以前没有用过mysql,有谁知道怎么写啊?
- mysql 客户端乱码
- mysql 创建中文表名,字段
- 表的联合问题,很慢,怎么优化
- MySQL 4.1.10 中文查询乱码
- 请教一条关于Mysql的or的用法
- 数据库设计问题
- CentOS 7 下 安装MariaDB 无法修改3306端口问题
- mysql 存储过程 致命问题,求救!~
- MySQL Administrator skip 不能进入安装模式
平时正常关机没出问题,突然断电重启会出现。
你可以把ibdata1和iblog文件备份后移走,再看MYSQL是否能启动。
重新安装MYSQL试试
my.cnf并没有对federated进行配置
[mysqld]
federated
每次重启还是会出现:[Note] Plugin 'FEDERATED' is disabled 等等
如果没有用到federated引擎,可以不用理会,只是1个提示
ibdata1 这里有很多数据还比较重要!删除后怎么完全恢复??
也就这3个文件ibdata1 、ib_logfile0、 ib_logfile1
主要是要找对方向,方向不对,解决起来就会走很多弯路。结果也不一定能解决问题。
我这里的原因很简单,是数据库引擎问题。 我一开始就高错了……
最主要的还是根据错误日志去找原因。