From: Date: October 16 2005 10:28am
Subject: RE: default table type = innodb is stable??
List-Archive: http://lists.mysql.com/mysql/190438
Message-Id: <4eo15g$dd824g@mail-iinet.icp-qv1-irony5.iinet.net.au>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

> this is my error log file.

> InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
> InnoDB: than specified in the .cnf file 0  268435456 bytes!

Your problem here is that you must have started MySQL when you had a 5MB
transaction log file specified, but you then put a new config file online
with a different log file size (256MB), InnoDB complains and dies.

You need to delete your old transaction log files (ib_logfile0) then start
MySQL and all should be fine.

Note: You should only delete your log files when you are absolutely sure
MySQL has shut down OK.

Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
  markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net