Having trouble loading 'mysql' gem

Question

I've started writing a Ruby script which will be called as part of rake db:seed, and it looks like this:

require 'rubygems'
require 'mysql'

When I try to run it, I get:

rake aborted!
cannot load such file -- mysql

However, I can use require 'mysql' from within irb, and I can do this:

$ gem query --local | grep mysql
mysql (2.9.0)

Does anybody know what's up?

e: for fun, I put puts Gem.path at the top of my script, and got:

/usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1
/home/vagrant/.gem/ruby/1.9.1

Compare that to Gem env:

 - /usr/local/rbenv/versions/1.9.3-p194/lib/ruby/gems/1.9.1
 - /home/vagrant/.gem/ruby/1.9.1

No dice.

Unrelated but I think you should use mysql2 instead http://stackoverflow.com/a/3003679/2033014 — mathieugagne, Feb 03 '13 at 02:56
That's useful. I'm curious to see if this magically fixes the original issue somehow. — Chris, Feb 03 '13 at 03:11
No, sadly, it didn't fix the original issue. I appreciate the recommendation, however. — Chris, Feb 03 '13 at 03:18

score 0 · Accepted Answer · answered Feb 03 '13 at 19:34

0

Answered. I had to add the following lines in my Gemfile:

gem 'mysql2'

After that, I ran bundle install and it worked.

answered Feb 03 '13 at 19:34

Chris

1 Answers1