execute failed: Unknown table engine 'InnoDB' 我用的是linux版的xampp。本来是好的,不过由于今天突然断电,机子重启后,在mysql中执行select语句就遇到这个错误,show engines,发觉只有7条记录,缺少了InnoDB这条记录。再show variables like "have_%",看到have_innodb的value是no。再看my.cnf,skip-innodb那行是注释掉的,文件设置也是对的。请问这种情况,我是不是只能重装xampp了,有没有什么办法不用重装这个软件?谢谢。
2. 看看my.cnf中有什么实质的相关内容
InnoDB: Unable to lock /opt/lampp/var/mysql/ibdata1,error:11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
101210 13:17:21 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock /opt/lampp/var/mysql/ibdata1,error:11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
.....
试试,不行就加大这个数字,最大可以加到6.提醒: 做好备份。
cannot find or open table XXX/XXX from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe ......改这个数字是不是没有用阿?我如果把ibdata1恢复成以前的那个文件,innodb又启不起来。
然后逐步加这个innodb_force_recovery=1
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
101210 15:17:41 InnoDB: Unable to open the first data file
InnoDB: Error in opening /opt/lampp/var/mysql/ibdata1
101210 15:17:41 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.htmlInnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
101210 15:17:41 [ERROR] Plugin 'InnoDB' init function returned error.
101210 15:17:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.101210 15:17:41 [Note] PrimeBase XT (PBXT) Engine 1.0.08 RC loaded...
InnoDB: Check that you do not already have another mysqld process你是不是已经有一个MYSQLD进程启动了?
InnoDB: Unable to lock /opt/lampp/var/mysql/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
而且mysql启动相当的慢。启动好后,我在mysql环境下对那个innodb数据库进行操作,都说unknown table engine 'InnoDB'。执行show engines,都没有innodb的纪录,have_innodb的值都是no。我想既然innodb引擎都找不到,那貌似该什么值都没用了。我在网上看到有说把这三个文件删掉,innodb引擎就可以起来了,然后我就把这三个文件移走了,重启mysql,innodb的问题解决了,但现在不认数据库里的table了。其实我这个数据库是bugzilla的数据库,数据库的建立是安装bugzilla时软件自动建的。我有用mysqldump备份数据库,是 .sql文件,我是不是source一下就可以啦?还是对于innodb型数据库,导入sql文件有别的说法啊?我现在都不敢动了。
我也碰到这问题了 也是把备份复制过去不能启动INNODB引擎 请问楼主“改宿主名为nobody:nobody”这句是什么意思
你啥mysql版本,所有innodb表空间多少G?能给我么?
ibdata1, ib_logfile0、ib_logfile1
查看Innodb这条信息就表示安装好了。
如果没有安装成功或者是在已经安装好mysql的情况下,只要执行下面语句再安装一次就OK。
install plugin innodb soname 'ha_innodb.so' ;