# Installing msql 5.0 into instant rials - InnoDB error

**URL:** <https://www.ruby-forum.com/t/installing-msql-5-0-into-instant-rials-innodb-error/151691>\
**Category:** Rails\
**Created:** [October 24, 2008, 1:07pm UTC](https://www.ruby-forum.com/t/installing-msql-5-0-into-instant-rials-innodb-error/151691 "2008-10-24T13:07:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![scudco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aca169/32.png) [@scudco](https://www.ruby-forum.com/u/scudco)\
**Post date:** [October 24, 2008, 1:07pm UTC](https://www.ruby-forum.com/t/installing-msql-5-0-into-instant-rials-innodb-error/151691/1 "2008-10-24T13:07:29Z")

</div>

Hi Im using a book based on 1.2\* ruby and rather than using instal rails  
to install all req. software it asks the user to do everthing  
individually. Well i already had instant rails working fine so thought  
id stick to it. The book wanted msql 5 to be installed and then select  
various options i.e. set password, internatinal character coding etc via  
the mysql windows config interface (rather than the command prompt.) To  
do this I installed msql into instantrails/mysql/ as per the  
instructions on instant raisl website.

However when i restart instantrails msql spits out an error whilst tring  
to start and after looking at the logs it says this

InnoDB: Error: log file .\ib\_logfile0 is of different size 0 5242880  
bytes  
InnoDB: than specified in the .cnf file 0 10485760 bytes!  
081024 19:09:14 [ERROR] Default storage engine (InnoDB) is not available  
081024 19:09:14 [ERROR] Aborting

081024 19:09:14 [Note] C:\INSTAN~1\MySql\bin\mysqld.exe: Shutdown  
complete

Ive tried reinstalling and changing various options but no luck. I did  
try installing it outside of instant rails and it worked fine.

Do i have to install it under instant rails if i use IRs command prompt  
for rails projects?

---

<div class="post-metadata">

**Author:** ![scudco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aca169/32.png) [@scudco](https://www.ruby-forum.com/u/scudco)\
**Post date:** [October 24, 2008, 1:08pm UTC](https://www.ruby-forum.com/t/installing-msql-5-0-into-instant-rials-innodb-error/151691/2 "2008-10-24T13:08:15Z")

</div>

Sorry I made a mistake that should have read a book based on rails 1.2\*

---

<div class="post-metadata">

**Author:** ![scudco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aca169/32.png) [@scudco](https://www.ruby-forum.com/u/scudco)\
**Post date:** [October 24, 2008, 2:44pm UTC](https://www.ruby-forum.com/t/installing-msql-5-0-into-instant-rials-innodb-error/151691/3 "2008-10-24T14:44:48Z")

</div>

On Oct 24, 12:07 pm, Adam A. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> to start and after looking at the logs it says this
> 
> InnoDB: Error: log file .\ib\_logfile0 is of different size 0 5242880  
> bytes  
> InnoDB: than specified in the .cnf file 0 10485760 bytes!  
> 081024 19:09:14 [ERROR] Default storage engine (InnoDB) is not available  
> 081024 19:09:14 [ERROR] Aborting

Sounds like your version of mysql was compiled without support for  
innodb.

Fred

---

<div class="post-metadata">

**Author:** ![scudco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aca169/32.png) [@scudco](https://www.ruby-forum.com/u/scudco)\
**Post date:** [October 24, 2008, 3:56pm UTC](https://www.ruby-forum.com/t/installing-msql-5-0-into-instant-rials-innodb-error/151691/4 "2008-10-24T15:56:57Z")

</div>

> Sounds like your version of mysql was compiled without support for  
> innodb.
> 
> Fred

hmm i am using a version that came with the book - its version 5 though.  
Ill try downloading it direct from the msql website. Why does mysql work  
fine when i install the same version outside of the IR directory?

---

<div class="post-metadata">

**Author:** ![scudco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aca169/32.png) [@scudco](https://www.ruby-forum.com/u/scudco)\
**Post date:** [October 24, 2008, 5:02pm UTC](https://www.ruby-forum.com/t/installing-msql-5-0-into-instant-rials-innodb-error/151691/5 "2008-10-24T17:02:06Z")

</div>

On 24 Oct 2008, at 14:56, Adam A. wrote:

> work  
> fine when i install the same version outside of the IR directory?

The configuration file, or the way the mysql server is launched can  
also do this sort of stuff, ie if the configuration file tried to do  
stuff with innodb settings but the server was launched with the option  
that turns off innodb support then you would probably also get that  
error.

Fred