Re: Plugin 'InnoDB' init function returned error. (fixed)
I got same problem, there is the error log:
===
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 33554432 bytes!
090105 9:17:08 [ERROR] Plugin 'InnoDB' init function returned error.
090105 9:17:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090105 9:17:08 [ERROR] Unknown/unsupported table type: INNODB
090105 9:17:08 [ERROR] Aborting
090105 9:17:08 [Note] D:\PROGRAM\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
===
so, what should I do? delete the .log files?
=== (Edit) ===
well, after I try to delete the old logfiles, it auto recovery and fixed.
just try to find your database "data folder", and delete ib_logfile(s).
(oops, remember backup your old files before delete!)
and the new err log looks like this:
===
090106 17:33:39 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 32 MB
InnoDB: Database physically writes the file full: wait...
090106 17:33:40 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 32 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090106 17:33:41 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090106 17:33:41 InnoDB: Started; log sequence number 0 1686420492
090106 17:33:42 [Note] Event Scheduler: Loaded 0 events
090106 17:33:42 [Note] D:\PROGRAM\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.28-rc-community' socket: '' port: 3309 MySQL Community Server (GPL)
===
I guess that will be happened when the "log file size" change ...
wish this information could help.
Edited 2 time(s). Last edit at 01/06/2009 03:42AM by YUEN-YI LIN.
Subject
Views
Written By
Posted
101247
March 16, 2007 06:31AM
54066
March 21, 2007 05:19AM
49481
June 03, 2008 02:29PM
Re: Plugin 'InnoDB' init function returned error. (fixed)
101004
January 06, 2009 03:22AM
40952
January 07, 2009 08:20AM
35618
February 10, 2009 01:26AM
55653
February 25, 2009 02:38AM
72376
February 27, 2009 10:21AM
20022
February 28, 2009 07:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.