innodb引擎Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
来源:互联网 发布:linux netcat rpm下载 编辑:程序博客网 时间:2024/06/08 08:46
今天在做innodb参数配置的时候,对其默认配置加以修改--结果导致启动后的server竟然不支持innodb引擎。Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
错误日志:
InnoDB: Data file /usr/local/mysql4/data/ibdata2 did not exist: new to be created
100702 14:34:53 InnoDB: Setting file /usr/local/mysql4/data/ibdata2 size to 20 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
100702 14:34:54 [ERROR] Plugin 'InnoDB' init function returned error.
100702 14:34:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
在遇到这些情况的时候,我起初考虑是没有建立新日志文件的权限。
实则不然
当我在未正常关闭server的情况下对其参数修改,
修改之后没有删除ib_logfile文件,ib_logfile文件中记录些innodb引擎非常有用的信息比如说默认的innodb默认的配置信息,你又是在未正常关闭server情况下操作的,所以导致重启后的server不支持innodb引擎。
rm -rf ib_logfile*
正确配置参数
重启server。
错误日志:
InnoDB: Data file /usr/local/mysql4/data/ibdata2 did not exist: new to be created
100702 14:34:53 InnoDB: Setting file /usr/local/mysql4/data/ibdata2 size to 20 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
100702 14:34:54 [ERROR] Plugin 'InnoDB' init function returned error.
100702 14:34:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
在遇到这些情况的时候,我起初考虑是没有建立新日志文件的权限。
实则不然
当我在未正常关闭server的情况下对其参数修改,
修改之后没有删除ib_logfile文件,ib_logfile文件中记录些innodb引擎非常有用的信息比如说默认的innodb默认的配置信息,你又是在未正常关闭server情况下操作的,所以导致重启后的server不支持innodb引擎。
rm -rf ib_logfile*
正确配置参数
重启server。
- innodb引擎Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
- innodb引擎Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
- Plugin 'InnoDB' registration as a STORAGE ENGINE failed
- Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
- Unknown storage engine 'InnoDB'
- 14.1.1 InnoDB as the Default MySQL Storage Engine
- ndbcluster引擎表同步到innodb引擎报错Error 'Unknown storage engine 'ndbcluster'
- MySQL备份/还原 Unknown storage engine 'InnoDB'
- MySQL error : unknown storage engine InnoDB
- mysql之Unknown storage engine 'InnoDB'
- Error Code: 1286 - Unknown storage engine 'InnoDB'
- 1286 Unknown storage engine 'InnoDB'的解决办法
- MySQL基础—InnoDB引擎(engine)
- Default storage engine (InnoDB) is not available解决办法
- Default storage engine (InnoDB) is not available解决办法
- Introduction to Transaction Locks in InnoDB Storage Engine
- <Chapter 2>Fast Index Creation in the InnoDB Storage Engine
- mysql的1067错误 Unknown/unsupported storage engine: InnoDB
- 命令行或者Console程序中文字颜色控制
- 初探aop
- 【几何---正方形覆盖】hdu 4007
- 为了您的健康,请对电脑作如下设置!
- 游戏中的架构
- innodb引擎Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
- Gootip让Twitter成为基于地理位置的问答平台,并发布iPhone应用
- 适配器模式和外观模式
- hibernate查询(模糊查询、子查询等)
- 工厂方法模式
- URLencode AND URLdecode
- 使用OpenFlow浏览图片
- 串口 函数1
- 第一章java网络编程入门