Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

Thanks!

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: bugs.mysql.com/bug.php?id=13494 –  CMag Sep 27 '11 at 22:55
    
mysqld is not starting up.... just seeing Starting MySQL........ –  CMag Sep 27 '11 at 22:55
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.