Forum: Ruby 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
n `require'
        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
n `require'
        from (irb):5
        from C:/Ruby193/bin/irb:12:in `<main>'

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" <lists@ruby-forum.com> 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 Weaver wrote in post #1086337:
> On Nov 25, 2012 5:27 PM, "Al Baker" <lists@ruby-forum.com> 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 <lists@ruby-forum.com> 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.