Somewhere inside the mysql directory Do you mean mysql folder under G:\Rails\rails_apps\music_library? This is where I'm running my music_library application.
That comment is > telling you to add that path to the environment variable called PATH I don't understand what you are saying here. Sorry I'm new to RoR. OK I've tried: G:\Rails\rails_apps\music_library>ruby mysql -v (since I noticed on windows one has to type 'ruby' first to run some commands. and I get: ruby: Permission denied -- mysql (LoadError) On Aug 7, 10:31 am, Frederick Cheung <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
