Hi Jeff Thanks for your reply.
Yes I installed the MySQL Community Server for Windows. I'm still struggling to check if mysql is installed for ruby. I installed mysql in the g:\program files\mysql directory & ruby on rails is installed in the g:\ruby directory. I'm running my music_library app in the g:\rails\rails_apps\music_library directory. Now the updated database.yml file says: On Windows: # gem install mysql # Choose the win32 build. # Install MySQL and put its /bin directory on your path. So I tried this command: G:\Rails\rails_apps>gem install mysql and I get: Successfully installed mysql-2.7.3-x86-mswin32 1 gem installed Installing ri documentation for mysql-2.7.3-x86-mswin32... Installing RDoc documentation for mysql-2.7.3-x86-mswin32... ERROR: While generating documentation for mysql-2.7.3-x86-mswin32 ... MESSAGE: Unhandled special: Special: type=17, text="<!-- $Id: README.html, v 1.20 2006-12-20 05:31:52 tommy Exp $ -->" ... RDOC args: --op g:/Ruby/lib/ruby/gems/1.8/doc/mysql-2.7.3-x86- mswin32/rdoc - -exclude ext --main README --quiet ext README docs/README.html (continuing with the rest of the installation) I'm not sure what it means by "put its /bin directory on your path" and I tried to copy the bin directory from the G:\Program Files\MySQL \MySQL Server 5.1 directory to the G:\Rails\rails_apps\music_library directory and run the following command to check if mysql is running ok: G:\Rails\rails_apps>mysql -v and I get the error: 'mysql' is not recognized as an internal or external command, operable program or batch file. Please help - where am I going wrong? Thanks Wal T On Aug 7, 12:00 am, Jeff <[email protected]> wrote: > On Aug 6, 4:10 pm, WalT <[email protected]> wrote: > > > Hi Guys > > > I'd like to know how to change from using sqlite3 to mysql. I'm > > running windows xp. What is the command that I must type under my > > application folder? How to I log into the mysql database afterwards? > > Assuming you have MySQL Community Server for Windows installed already > (if not, go to mysql.com to download it), then change > yourdatabase.ymlsections to look like this, for example: > > development: > adapter: mysql > encoding: utf8 > reconnect: false > database: hockey_development > pool: 5 > username: root > password: > host: localhost > > Of course you want to change the database name, username, and password > as needed (use the same username and password as you did when you > installed the mysql server). > > And for future rails apps, you can have rails build this for > automatically: > > C:\dev> rails myapp -d mysql > > Hope this helps? > > Jeff > > book: Rails for .NET Developers:www.pragprog.com/titles/cerailn > blog: softiesonrails.com > web: purpleworkshops.com > > > Mydatabase.ymlfile contents at the moment are: > > # SQLite version 3.x > > # gem install sqlite3-ruby (not necessary on OS X Leopard) > > development: > > adapter: sqlite3 > > database: db/development.sqlite3 > > pool: 5 > > timeout: 5000 > > > # Warning: The database defined as "test" will be erased and > > # re-generated from your development database when you run "rake". > > # Do not set this db to the same as development or production. > > test: > > adapter: sqlite3 > > database: db/test.sqlite3 > > pool: 5 > > timeout: 5000 > > > production: > > adapter: sqlite3 > > database: db/production.sqlite3 > > pool: 5 > > timeout: 5000 > > > Thanks in advance. > > > Wal T --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
