I’ve set up on Windows 7 Eclipse with ruby 1.8.7 and rails 3.2.2 and
radrails plugin and want to use MySQL as a database, not sqlit3.
I’ve executed: gem install mysql2
And changed the database.yml
I have tried to use MySQL 5.5 and 5.1 and the error still exists.
rake aborted!
Please install the mysql adapter: gem install activerecord-mysql-adapter (mysql is not part of the bundle. Add it to
Gemfile.)
If I execute: gem install activerecord-mysql-adapter it says it doesnt
exist.
I’ve also copied a libmysql dll into de ruby .bin folder.
Any help? I have searched everywhere and cant get it fix.
How and where in the gem file do I add what?
On another note, if I have 2 tables, one with its primary key being a
foreign key, does RoR automatically create a <columname_to> on that
table?
Thanks in advance, im stuck 
On Apr 3, 10:48pm, “Miguel A.” [email protected] wrote:
I’ve set up on Windows 7 Eclipse with ruby and radrails and want to use
MySQL as a database.
I’ve executed: gem install mysql2
And changed the database.yml
what did you change it to? I’d wager you’ve got adapter: mysql,
whereas it should be adapter mysql2
Any help? I have searched everywhere and cant get it fix.
How and where in the gem file do I add what?
Your Gemfile lists all the gems your app uses, if you’re using the
mysql2 gem you’d need
gem ‘mysql2’
(If you’re using an older rails version you may need to specify a
version of mysql2 that is compatible with your rails version.
On another note, if I have 2 tables, one with its primary key being a
foreign key, does RoR automatically create a <columname_to> on that
table?
Not sure I quite get the question, but rails doesn’t create any
columns automatically. Use a migration to add tables or change
existing tables. There are a few shortcuts you can use in the
migration / generators (e.g. rails g model1 model2:belongs_to will add
a column called model2_id as well as an index)
Fred
Your Gemfile lists all the gems your app uses, if you’re using the
mysql2 gem you’d need
gem ‘mysql2’
(If you’re using an older rails version you may need to specify a
version of mysql2 that is compatible with your rails version.
Im using rails 3.2.2 and in my:
C:\Ruby187\lib\ruby\gems\1.8\gems
folder I can see the:
mysql-2.8.1-x86-mingw32, mysql2-0.3.11-x86-mingw32 and
mysql2-0.3.11-x86-mswin32-60
folders.
Doesn’t this mean its installed already? 
On Apr 3, 11:06pm, “Miguel A.” [email protected] wrote:
Im using rails 3.2.2 na in my:
C:\Ruby187\lib\ruby\gems\1.8\gems
folder I can see the:
mysql-2.8.1-x86-mingw32, mysql2-0.3.11-x86-mingw32 and
mysql2-0.3.11-x86-mswin32-60
folders.
Doesn’t this mean its installed already? 
Your rails app will only use the gems specified in your Gemfile (and
their dependencies). If it’s not in your Gemfile, it’s not loaded,
even if it is already installed
Fred
Your rails app will only use the gems specified in your Gemfile (and
their dependencies). If it’s not in your Gemfile, it’s not loaded,
even if it is already installed
Fred
Thank you for the explanation and time dedicated Fred
Best regards
