What does "no such file to load -- mysql" mean?

Added by Trevor Harmon over 8 years ago

I had a Redmine installation that was working fine on one server, but when I moved it to a different one (with a difference configuration), it broke. I was able to fix most of the issues by installing some missing Gems, but I'm still getting an error that I can't figure out:

no such file to load -- mysql (MissingSourceFile)

Looking at the source, it appears this may simply be a missing mysql Gem. Can anyone confirm this? I'm asking because I can't seem to install the Gem, and I'd like to know if that's really the problem before spending a lot of time trying to install it.

Thanks!

Replies (4)

RE: What does "no such file to load -- mysql" mean? - Added by Jean-Philippe Lang over 8 years ago

It seems like you're missing the mysql gem. Please try gem install mysql.

RE: What does "no such file to load -- mysql" mean? - Added by Trevor Harmon over 8 years ago

That was indeed the problem. I needed help from my hosting provider to install the gem, but after that Redmine was working fine. Thanks!

RE: What does "no such file to load -- mysql" mean? - Added by Jared Fine over 7 years ago

Don't want to revive an old thread but I just ran into this issue and it was due to upgrading Ruby from 1.8.7 to 1.9.3. If you do that, make sure to update your config/database.yml adaptor to use mysql2 instead of mysql.

RE: What does "no such file to load -- mysql" mean? - Added by Ivan Cenov over 7 years ago

Jared Fine wrote:

Don't want to revive an old thread but I just ran into this issue and it was due to upgrading Ruby from 1.8.7 to 1.9.3. If you do that, make sure to update your config/database.yml adaptor to use mysql2 instead of mysql.

...and to download libmysql.dll from http://www.mysql.com/downloads/connector/c/ (6.0.2).

(1-4/4)