List:Internals« Previous MessageNext Message »
From:Paul DuBois Date:January 23 2010 12:14am
Subject:Re: moving InnoDB data from 5.4.2 to 5.5.1-m2
View as plain text  
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

Thread
moving InnoDB data from 5.4.2 to 5.5.1-m2Zardosht Kasheff22 Jan
  • Re: moving InnoDB data from 5.4.2 to 5.5.1-m2Mark Leith22 Jan
    • Re: moving InnoDB data from 5.4.2 to 5.5.1-m2Zardosht Kasheff22 Jan
      • Re: moving InnoDB data from 5.4.2 to 5.5.1-m2Shane Bester22 Jan
        • Re: moving InnoDB data from 5.4.2 to 5.5.1-m2Paul DuBois23 Jan