| 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 Onn | 14 Oct |
| • Re: default table type = innodb is stable?? | Ady Wicaksono | 14 Oct |
| • Re: default table type = innodb is stable?? | Hiu Yen Onn | 15 Oct |
| • Re: default table type = innodb is stable?? | Hiu Yen Onn | 15 Oct |
| • Re: default table type = innodb is stable?? | Jigal van Hemert | 15 Oct |
| • Re: default table type = innodb is stable?? | Hiu Yen Onn | 16 Oct |
| • RE: default table type = innodb is stable?? | Richard Dale | 16 Oct |
| • Re: default table type = innodb is stable?? | Hiu Yen Onn | 17 Oct |
| • Re: default table type = innodb is stable?? | Gleb Paharenko | 15 Oct |
