On Jan 22, 2010, at 4:48 PM, Shane Bester wrote:
> Hi!
>
>> I did. That is why I got this error. .\iblogfile0 was copied from 5.4.2
>
>>>> InnoDB: Error: log file .\ib_logfile0 is of different size 0 134217728
>>>> bytes
>>>> InnoDB: than specified in the .cnf file 0 5242880 bytes!
>>>> 100122 10:13:09 [ERROR] Plugin 'InnoDB' init function returned error.
>>>> 100122 10:13:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
>>>> failed.
>>>>
>
> Edit your my.ini and add/modify this in [mysqld]:
>
> innodb_log_file_size=128M
Another option is to shut down your server cleanly and discard the log files. Then restart
the server and let it recreate them at the new, smaller size. This way you won't have to
devote so much disk to them. See the InnoDB notes in the following, mentally
substituting 5.5.1 whenever you see 5.4.3:
http://dev.mysql.com/doc/refman/5.4/en/upgrading-from-previous-series.html
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com