I''ve been struggling with getting MySQL working on my work box running Windows XP. I installed DBI and DBD but kept seeing errors. Here are the two actions that finally got it running: 1) Downloaded mysql.so from http://seagecko.org/thoughts/2004/09/09/ruby-mysql-and-windows/ (thanks, Justin) and installed it in /ruby/lib/ruby/site_ruby/1.8/i386-msvcrt. That changed my error message to one that said something like "can''t find mysql_character_code_somethingorother in LIBMYSQL.DLL". 2) Copied /mysql/lib/opt/libmysql.dll to /windows/system32, replacing the libmySQL.dll that was already there. Now I can use DBI and---even better---Rails on my work box. Yay! I hope these two tips help somebody else. Jim -- Jim Menard, jimm-Xhj3G7Rj6JI@public.gmane.org, http://www.io.com/~jimm
I suggest to use XAMPP on windows. On Thu, 06 Jan 2005 15:12:13 -0500, Jim Menard <jimm-Xhj3G7Rj6JI@public.gmane.org> wrote:> I''ve been struggling with getting MySQL working on my work box running Windows > XP. I installed DBI and DBD but kept seeing errors. Here are the two actions > that finally got it running: > > 1) Downloaded mysql.so from > http://seagecko.org/thoughts/2004/09/09/ruby-mysql-and-windows/ (thanks, > Justin) and installed it in /ruby/lib/ruby/site_ruby/1.8/i386-msvcrt. That > changed my error message to one that said something like "can''t find > mysql_character_code_somethingorother in LIBMYSQL.DLL". > > 2) Copied /mysql/lib/opt/libmysql.dll to /windows/system32, replacing the > libmySQL.dll that was already there. > > Now I can use DBI and---even better---Rails on my work box. Yay! I hope these > two tips help somebody else. > > Jim > -- > Jim Menard, jimm-Xhj3G7Rj6JI@public.gmane.org, http://www.io.com/~jimm > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- Tobi http://www.hieraki.org - Open source book authoring http://blog.leetsoft.com - Technical weblog
Jim Menard wrote:> > I''ve been struggling with getting MySQL working on my work box > running Windows > XP. I installed DBI and DBD but kept seeing errors. Here are the > two actions > that finally got it running: > > 1) Downloaded mysql.so from > http://seagecko.org/thoughts/2004/09/09/ruby-mysql-and-windows/ (thanks, > Justin) and installed it in > /ruby/lib/ruby/site_ruby/1.8/i386-msvcrt. That > changed my error message to one that said something like "can''t find > mysql_character_code_somethingorother in LIBMYSQL.DLL". > > 2) Copied /mysql/lib/opt/libmysql.dll to /windows/system32, replacing the > libmySQL.dll that was already there. > > Now I can use DBI and---even better---Rails on my work box. Yay! > I hope these > two tips help somebody else.I''m not sure why you had to go to all that trouble... for me, I just installed Ruby with te One-Click installer and them at the command line ran "gem install rails" (which includes MySQL support). I can then use MySQL with Rails -- no problem (I never tried DBI or DBD, though). Curt
Tobias Luetke wrote:> I suggest to use XAMPP on windows.I would, except I think I''ve got to stick with MySQL 4.0.20 for now, and XAMPP uses MySQL 4.1.8. Time to see about upgrading. Jim -- Jim Menard, jimm-Xhj3G7Rj6JI@public.gmane.org, http://www.io.com/~jimm
Curt,> I''m not sure why you had to go to all that trouble... for me, I just > installed Ruby with te One-Click installer and them at the command line ran > "gem install rails" (which includes MySQL support). I can then use MySQL > with Rails -- no problem (I never tried DBI or DBD, though).I used gem to install rails. The MySQL connection didn''t work, but that could be because I had previously installed DBI/DBD. Jim -- Jim Menard, jimm-Xhj3G7Rj6JI@public.gmane.org, http://www.io.com/~jimm