Windows Vista and “gem install mysql”
January 24th, 2009
I just got this message with Rails 2.2.2 and a MySQL 5.0.x DB on Windows Vista as i tried to rake db:create
The specified module could not be found. - c:/ruby/lib/ruby/gems/1.8/gems/mysql-2.7.3-x86-mswin32/ext/mysql.so
After penetrating google for some time i found a solution that was working for me. All you have to do is to copy your libmySQL.dll from your MySQL bin directory to your ruby bin directory.
Had the same problem at work.
The real pain in the ass is that the most current libmySQL.dll doesn’t seem to work all that good for specific edge cases. So if you ever receive strange error messages, try to switch to a lower version of the dll