Rake db:create => LIBMYSQL.DLL not found. how to solve?

#1

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?

#2

[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

#3

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-

#4

Frederick C. 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

#5

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

#6

Rails T. 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.

#7

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.

#8

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

#9

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
removed_email_address@domain.invalid

Sent from my iPhone

#10

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
removed_email_address@domain.invalid

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.

#11

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

#12

For further details about this issue, refer to the post -
http://rorguide.blogspot.com/2011/03/installing-mysql2-gem-on-ruby-192-and.html

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

#13

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
removed_email_address@domain.invalid

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.