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 your database.yml sections 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 > My database.yml file 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 -~----------~----~----~----~------~----~------~--~---
