I’d really like to give MySQL a try too. With an earlier version of the book (and presumably an earlier version of rails) I did not have too much trouble. But now I am struggling. I’ve uninstalled all my gems, uninstalled ruby, and reinstalled everything and started building an app. But I am still seeing problems with the MySQL driver.
Here is how I was able to at least install it:
$ sudo gem install mysql – –with-mysql-config=/usr/local/mysql/bin/mysql_config
But I still can’t migrate:
$ rake db:migrate … !!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql. rake aborted! dlsym(0x155bc50, Init_mysql): symbol not found - /opt/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle
I do have the mysql gem:
$ gem list|grep mysql activerecord-jdbcmysql-adapter (0.9) jdbc-mysql (5.0.4) mysql (2.7)
My environment is Mac OS 10.5.6 and I upgraded to Ruby 1.8.7 and rail 2.2.2. I hope I can get this working, or I may have to revert to sqlite3.
Thanks for any help.