Forum: Ruby on Rails rake db:create => LIBMYSQL.DLL not found. how to solve????

Cd29de28054896ac54ce13c836368733?d=identicon&s=25 globalrev (Guest)
on 2008-04-23 03:22
(Received via mailing list)
ruby.exe - Unable to locate Component
This application has failed to start because LIBMYSQL.DLL was not
found. Re-installing the application might
fix this problem.


i get that message when running rake db:create
from what directory should i run rake db:create?
2b1df44ef63bbf410976ef082d0d5d8b?d=identicon&s=25 Yacobus Reinhart (malioboro)
on 2008-04-23 04:46
[1] gem install mysql
[2] you will see like error syntac but dont pay attention to it
[3] find LIBMYSQL.DLL from your mysql/bin folder in your mysql folder
not ruby folder.
[4] copy & paste that file to ruby/bin
[5] restart your server or console, if you are already run it.

Then Cheer,
Reinhart
http://teapoci.blogspot.com
Cd29de28054896ac54ce13c836368733?d=identicon&s=25 globalrev (Guest)
on 2008-04-23 05:17
(Received via mailing list)
do i need to download(and pay for) mysql separately from www.mysql.com?
what does gem install mysql do? downloads and installs it or just
downloads some Rails-Mysql-connectivity?


On 23 Apr, 04:46, Visit Indonesia 2008 <rails-mailing-l...@andreas-
81b61875e41eaa58887543635d556fca?d=identicon&s=25 Frederick Cheung (Guest)
on 2008-04-23 08:50
(Received via mailing list)
On 23 Apr 2008, at 04:16, globalrev wrote:

>
> do i need to download(and pay for) mysql separately from
> www.mysql.com?
mysql is free (look for the 'community server' stuff, as there is also
stuff you can pay for if you want technical support and that sort of
thing).
>
> what does gem install mysql do? downloads and installs it or just
> downloads some Rails-Mysql-connectivity?
it's the library through which ruby (and therefore rails) accesses
mysql.

Fred
602eee4d9f83067a8920ed9b9fc53b13?d=identicon&s=25 Herb Bowers (herbbowers)
on 2009-07-07 15:44
Frederick Cheung wrote:
> On 23 Apr 2008, at 04:16, globalrev wrote:
>
>>
>> do i need to download(and pay for) mysql separately from
>> www.mysql.com?
> mysql is free (look for the 'community server' stuff, as there is also
> stuff you can pay for if you want technical support and that sort of
> thing).
>>
>> what does gem install mysql do? downloads and installs it or just
>> downloads some Rails-Mysql-connectivity?
> it's the library through which ruby (and therefore rails) accesses
> mysql.
>
> Fred

I just experienced the same problem and after a Google on the phrase,
the general consensus among those who offered solutions worked for me
also. It seems that MySQL 5.1 does not play well with Ruby. I resolved
this by downloading the 5.0 version. More specifically:
“mysql-noinstall-5.0.83-win32.zip”. Remove bin/libmysql.dll from the zip
file and place it in Ruby/bin/. This worked for me.
Good luck.
Herb
7ea637318b43f3a89c39cd0614af0a57?d=identicon&s=25 Vicer Ontero (vicer)
on 2009-08-04 02:52
>
> I just experienced the same problem and after a Google on the phrase,
> the general consensus among those who offered solutions worked for me
> also. It seems that MySQL 5.1 does not play well with Ruby. I resolved
> this by downloading the 5.0 version. More specifically:
> “mysql-noinstall-5.0.83-win32.zip”. Remove bin/libmysql.dll from the zip
> file and place it in Ruby/bin/. This worked for me.
> Good luck.
> Herb

Hi Herb,
        Thanks a lot. Copying libmysql.dll to Ruby/bin seems to have
worked for me too.

Cheers.
35051b0a5ae78866e69f61a8d73e1d6e?d=identicon&s=25 Manish Nautiyal (manish812)
on 2010-05-23 15:55
Rails Terrorist wrote:
> [1] gem install mysql
> [2] you will see like error syntac but dont pay attention to it
> [3] find LIBMYSQL.DLL from your mysql/bin folder in your mysql folder
> not ruby folder.
> [4] copy & paste that file to ruby/bin
> [5] restart your server or console, if you are already run it.
>
> Then Cheer,
> Reinhart
> http://teapoci.blogspot.com

Thanx Reinhart

this helps me to run rails on windows.
B4fa23d09a88d246677d14a8204ca8c4?d=identicon&s=25 Sagar Jhobalia (sagar_jhobalia)
on 2010-08-24 00:06
m trying to run my hello world prgm<since 3hrs now!!> pls help..1st i
got the above stated error..on solvin tat<thnks 2 u'll> now i am getting
:

/!\ FAILSAFE /!\  2010-08-24 03:27:09 +0530
  Status: 500 Internal Server Error
  Unknown database 'demo_development'
    C:/Ruby19/lib/ruby/gems/1.9.1/gems/activerecord-2.3.8/lib/active_record/conn
ection_adapters/mysql_adapter.rb:619:in `real_connect'...............

help plz
Dd2d775dea75b381edb1bbf0600a0907?d=identicon&s=25 Marnen Laibow-Koser (marnen)
on 2010-08-24 01:25
Sagar Jhobalia wrote:
> m trying to run my hello world prgm<since 3hrs now!!> pls help..1st i
> got the above stated error..on solvin tat<thnks 2 u'll> now i am getting
> :
>
> /!\ FAILSAFE /!\  2010-08-24 03:27:09 +0530
>   Status: 500 Internal Server Error
>   Unknown database 'demo_development'
>     C:/Ruby19/lib/ruby/gems/1.9.1/gems/activerecord-2.3.8/lib/active_record/conn
> ection_adapters/mysql_adapter.rb:619:in `real_connect'...............
>
> help plz

It means just what it says.  Does the DB exist yet?

Best,
-- 
Marnen Laibow-Koser
http://www.marnen.org
marnen@marnen.org

Sent from my iPhone
B4fa23d09a88d246677d14a8204ca8c4?d=identicon&s=25 Sagar Jhobalia (sagar_jhobalia)
on 2010-08-24 14:36
Marnen Laibow-Koser wrote:
> Sagar Jhobalia wrote:
>> m trying to run my hello world prgm<since 3hrs now!!> pls help..1st i
>> got the above stated error..on solvin tat<thnks 2 u'll> now i am getting
>> :
>>
>> /!\ FAILSAFE /!\  2010-08-24 03:27:09 +0530
>>   Status: 500 Internal Server Error
>>   Unknown database 'demo_development'
>>     C:/Ruby19/lib/ruby/gems/1.9.1/gems/activerecord-2.3.8/lib/active_record/conn
>> ection_adapters/mysql_adapter.rb:619:in `real_connect'...............
>>
>> help plz
>
> It means just what it says.  Does the DB exist yet?
>
> Best,
> -- 
> Marnen Laibow-Koser
> http://www.marnen.org
> marnen@marnen.org
>
> Sent from my iPhone

i don't understand,i mean i've installed the mysql,& the application
itself requires no access of database..so..i stil dont know what am i
suppossed to do.
7ea637318b43f3a89c39cd0614af0a57?d=identicon&s=25 Vicer Ontero (vicer)
on 2010-08-24 15:07
Sagar Jhobalia wrote:
> Marnen Laibow-Koser wrote:
>> Sagar Jhobalia wrote:
>>> m trying to run my hello world prgm<since 3hrs now!!> pls help..1st i
>>> got the above stated error..on solvin tat<thnks 2 u'll> now i am getting
>>> :
>>>
>>> /!\ FAILSAFE /!\  2010-08-24 03:27:09 +0530
>>>   Status: 500 Internal Server Error
>>>   Unknown database 'demo_development'
>>>     C:/Ruby19/lib/ruby/gems/1.9.1/gems/activerecord-2.3.8/lib/active_record/conn
>>> ection_adapters/mysql_adapter.rb:619:in `real_connect'...............
>>>
>>> help plz
>>
>> It means just what it says.  Does the DB exist yet?
>>
>> Best,
>> -- 
>> Marnen Laibow-Koser
>> http://www.marnen.org
>> marnen@marnen.org
>>
>> Sent from my iPhone
>
> i don't understand,i mean i've installed the mysql,& the application
> itself requires no access of database..so..i stil dont know what am i
> suppossed to do.

check you config/database.yml page. obviously it mentions a database
named 'demo_development'.

just like Marnen has mentioned above, it must be because this database
does not exist that you are getting this error.
A8cb7ed63198af5384437d8f45b45da1?d=identicon&s=25 Chaitanya M. (chaitanya_m)
on 2011-05-17 23:07
This worked for me. A minor correction: libmysql.dll is in mysql/lib
folder and paste it to your ruby/bin folder!!!

Yacobus Reinhart wrote in post #664497:
> [1] gem install mysql
> [2] you will see like error syntac but dont pay attention to it
> [3] find LIBMYSQL.DLL from your mysql/bin folder in your mysql folder
> not ruby folder.
> [4] copy & paste that file to ruby/bin
> [5] restart your server or console, if you are already run it.
>
> Then Cheer,
> Reinhart
> http://teapoci.blogspot.com
5318596a48edb2c5d599164ada4f1955?d=identicon&s=25 Ritesh Kumar (riteshkumar)
on 2011-05-19 14:06
For further details about this issue, refer to the post -
http://rorguide.blogspot.com/2011/03/installing-my...

This along with many other issues of mysql2 gem has already been solved
by many users and they have posted their solutions also.

Thanks
Ritesh Kumar
http://rorguide.blogspot.com
Please log in before posting. Registration is free and takes only a minute.
Existing account

NEW: Do you have a Google/GoogleMail, Yahoo or Facebook account? No registration required!
Log in with Google account | Log in with Yahoo account | Log in with Facebook account
No account? Register here.