Mysql drama!

I’m havng trouble using mysql in my example.

i alreeady did the gem install and copied the “libmysql.dll” over to bin
but still got this:

irb(main):005:0> require ‘mysql’
LoadError: cannot load such file – mysql/mysql_api
from
C:/Ruby193/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:i
n require' from C:/Ruby193/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:i nrequire’
from
C:/Ruby193/lib/ruby/gems/1.9.1/gems/mysql-2.9.0-x86-mingw32/lib/mys
ql.rb:6:in rescue in <top (required)>' from C:/Ruby193/lib/ruby/gems/1.9.1/gems/mysql-2.9.0-x86-mingw32/lib/mys ql.rb:2:in<top (required)>’
from
C:/Ruby193/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:i
n require' from C:/Ruby193/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:i nrequire’
from (irb):5
from C:/Ruby193/bin/irb:12:in `’

any ideas?

Did you find a solution?

I did not know on Windows you had to copy the .dll to bin yourself. That
seems odd.

unfortunately no i didn’t dunno whta happened. i’m using windows 7

On Nov 25, 2012 5:27 PM, “Al Baker” [email protected] wrote:

unfortunately no i didn’t dunno whta happened. i’m using windows 7


Posted via http://www.ruby-forum.com/.

Look into mysql2, it’s a C based library.

Brandon W. wrote in post #1086337:

On Nov 25, 2012 5:27 PM, “Al Baker” [email protected] wrote:

unfortunately no i didn’t dunno whta happened. i’m using windows 7


Posted via http://www.ruby-forum.com/.

Look into mysql2, it’s a C based library.
will that make thigns better?

On Sun, Nov 25, 2012 at 9:05 PM, Al Baker [email protected] wrote:

will that make thigns better?


Posted via http://www.ruby-forum.com/.

It should make things faster, and I haven’t experienced a good portion
of
the snafus with mysql2. It takes a bit of work to get it up past a gem
install, but it’s worth it.

Also worth a look: Sequel.