I had installed MySQL Server 5.5 on Windows Server 2008 R2 before 2 months and it's working till now. But suddenly MySQL Service goes down and I am not able to restart the service. Error Message:
121120 14:33:31 [Note] Plugin 'FEDERATED' is disabled.
121120 14:33:31 InnoDB: The InnoDB memory heap is disabled
121120 14:33:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121120 14:33:31 InnoDB: Compressed tables use zlib 1.2.3
121120 14:33:31 InnoDB: Initializing buffer pool, size = 2.0G
121120 14:33:31 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 95420416 bytes
InnoDB: than specified in the .cnf file 0 224395264 bytes!
121120 14:33:31 [ERROR] Plugin 'InnoDB' init function returned error.
121120 14:33:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121120 14:33:31 [ERROR] Unknown/unsupported storage engine: INNODB
121120 14:33:31 [ERROR] Aborting
121120 14:33:31 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete
How can I resolve this issue?
This is the error:
InnoDB: Error: log file .\ib_logfile0 is of different size 0 95420416 bytes
InnoDB: than specified in the .cnf file 0 224395264 bytes!
What you can do is search for that .cnf file and change the bytes from 224395264 to 95420416
Mayby that helps....
UPDATE as mentiod here: Change InnoDB Log File Size
Can you delete the log file ( .\ib_logfile0 ) when the server isn't running, and then the problem souldn't be there anymore...