MySQL Innodb: log file .\ib_logfile0 is of different size

Posted Tue, 2010-12-28 14:48 by Kayode Odeyemi
InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
101228  9:31:07 [ERROR] Default storage engine (InnoDB) is not available
101228  9:31:07 [ERROR] Aborting
101228  9:31:07 [Note] wampmysqld: Shutdown complete

Solution: One of the reasons you are seeing this in your mysql log file is that you have changed the parameter innodb_log_file_size.This will allow mysql to perform a checkpoint on the log buffer - this action is similar to what you will experience in Oracle as well.  To resolve this,

  • Stop MySQL
  • Change to your data directory
  • Delete the log files
  • Restart MySQL
»

Post new comment

The content of this field is kept private and will not be shown publicly.