List:General Discussion« Previous MessageNext Message »
From:Richard Dale Date:October 16 2005 10:28am
Subject:RE: default table type = innodb is stable??
View as plain text  
> 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 

Thread
default table type = innodb is stable??Hiu Yen Onn14 Oct
  • Re: default table type = innodb is stable??Ady Wicaksono14 Oct
    • Re: default table type = innodb is stable??Hiu Yen Onn15 Oct
      • Re: default table type = innodb is stable??Hiu Yen Onn15 Oct
  • Re: default table type = innodb is stable??Jigal van Hemert15 Oct
    • Re: default table type = innodb is stable??Hiu Yen Onn16 Oct
      • RE: default table type = innodb is stable??Richard Dale16 Oct
        • Re: default table type = innodb is stable??Hiu Yen Onn17 Oct
  • Re: default table type = innodb is stable??Gleb Paharenko15 Oct