On Aug 7, 9:08 am, WalT <[email protected]> wrote: > > 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. > Somewhere inside the mysql directory there is a folder called bin with the mysql command line utility and various DLLs. That comment is telling you to add that path to the environment variable called PATH (which has the effect that windows will look in that folder when it tries to find what application it should run when you type mysql) If my windows memory is correct you can edit environment variables from somewhere in the control panel.
Fred > 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 -~----------~----~----~----~------~----~------~--~---
