How to fixs [ERROR] Unknown/unsupported storage engine: InnoDB

July 2, 2012 | Filed underDatabase | Posted by

mysql logo
I’ve upgraded MySQL 5.0 to MySQL 5.5 with MySQL databases. When I start MySQL the service could not be started. I checked the Mysql error logs, saw below errors:

InnoDB: Error: log file ./ib_logfile2 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
120702 11:44:05 [ERROR] Plugin 'InnoDB' init function returned error.
120702 11:44:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120702 11:44:05 [ERROR] Unknown/unsupported storage engine: InnoDB
120702 11:44:05 [ERROR] Aborting

For solution, I remove the ib_logfile files and start MySQL again. Now this time, it is working fine.

[root@mysql]# rm -f ib_logfile*
Incoming search terms: Unknown/unsupported storage engine: InnoDB, unknown/unsupported storage engine innodb como resolver

Related posts:

  1. How to change the storage engine for MySQL tables MySQL server sets the MyISAM to default of storage engine which is storage engine that faster and simpler. However the MyISAM doesn’t support transactions and operations are slow when frequently...
  2. How to fix “The Used Table Type Doesn’t Support FULLTEXT Indexes” when convert a MySQL table to InnoDB I received “The Used Table Type Doesn’t Support FULLTEXT Indexes” message when I was trying to convert a MySQL table from MyISAM to InnoDB storage engine. The cause of error...
  3. How to solve “Fatal error: Allowed memory size of 33554432 bytes exhausted …” If your WordPress blog to get the error code below: Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 30720 bytes) in /home/xxx/public_html/imbloger.ner/wp-admin/includes/xxx.php on line xxx This...
  4. Fix iTunes Error 3194 while restoring iOS firmware How to fix iTunes error 3194 while restoring either stock, or custom firmware/iOS on iPhone / iPad / iPad. iTunes error 3194 means iTunes failed to get SHSH blobs from...

Leave a Response

Your email address will not be published. Required fields are marked *

*

CAPTCHA Image

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>