Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

seeing the following in my mysql error log file:

InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
110927 18:36:37 [ERROR] Plugin 'InnoDB' init function returned error.
110927 18:36:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

How can this be easily fixed?


share|improve this question
ll -h | grep ib -rw-rw---- 1 mysql mysql 4.1G Sep 27 13:50 ibdata1 -rw-rw---- 1 mysql mysql 5.0M Sep 27 13:50 ib_logfile0 -rw-rw---- 1 mysql mysql 5.0M Sep 26 11:45 ib_logfile1 – CMag Sep 27 '11 at 22:42
tried: – CMag Sep 27 '11 at 22:55
mysqld is not starting up.... just seeing Starting MySQL........ – CMag Sep 27 '11 at 22:55

As the error says, in your my.cnf you must have innodb_log_file_size= 256M.

So stop your MYSQL server, rename the ib_logfile0 & ib_logfile1 files, then restart your server. It should create two new files each 256M in size.

How you got into this situation is an important question. Trying to restore an old backup? i.e. Before the innodb_log_file_size was changed in your my.cnf.

share|improve this answer
This is pretty much the answer. What took so long for anyone to upvote this (Rhetorical) ??? +1 !!! – RolandoMySQLDBA Sep 28 '11 at 20:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.