I'll try again....
Walt, when you say that this happened:
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.
then it means that Windows is telling you that it can't find the
"mysql" program, right?
And if that's true, then Ruby also has no way to talk to mysql
either. Hence all the advice about making sure that the mysql.exe is
in your PATH. If you're not sure how to find mysql.exe or adjust your
PATH, you'll need to ask for basic Windows help, which is beyond the
scope of this forum
However, assuming this all makes sense to you now, I'd suggest:
1. Adjust your PATH so that you can successfully run "mysql -v"
2. Re-installing the mysql gem: hopefully now it can find the
mysql.exe binary in your path
Does that make sense?
Thanks
Jeff
purpleworkshops.com
softiesonrails.com
pragprog.com/titles/cerailn
On Aug 7, 2:32 pm, WalT <[email protected]> wrote:
> > No, he means the directory where mySQL is installed.
>
> I mentioned above that there's a bin folder in the directory where
> mysql is installed: G:\Program Files\MySQL
> \MySQL Server 5.1.
>
> 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.
>
> > This has nothing to do with Rails. It's a basic Windows (and Un*x)
> > concept. Go learn about it; this is elementary and you need to know.
>
> I disagree - this is not a windows concept. It's a ruby concept. Can
> someone else please help me to use mysql with ruby? I can see that
> under directory G:\Rails\rails_apps\music_library\config there's a
> file called environment.rb and its contents are:
>
> # Be sure to restart your server when you modify this file
>
> # Specifies gem version of Rails to use when vendor/rails is not
> present
> RAILS_GEM_VERSION = '2.3.3' unless defined? RAILS_GEM_VERSION
>
> # Bootstrap the Rails environment, frameworks, and default
> configuration
> require File.join(File.dirname(__FILE__), 'boot')
>
> Rails::Initializer.run do |config|
> # Settings in config/environments/* take precedence over those
> specified here.
> # Application configuration should go into files in config/
> initializers
> # -- all .rb files in that directory are automatically loaded.
>
> # Add additional load paths for your own custom dirs
> # config.load_paths += %W( #{RAILS_ROOT}/extras )
>
> # Specify gems that this application depends on and have them
> installed with rake gems:install
> # config.gem "bj"
> # config.gem "hpricot", :version => '0.6', :source => "http://
> code.whytheluckystiff.net"
> # config.gem "sqlite3-ruby", :lib => "sqlite3"
> # config.gem "aws-s3", :lib => "aws/s3"
>
> # Only load the plugins named here, in the order given (default is
> alphabetical).
> # :all can be used as a placeholder for all plugins not explicitly
> named
> # config.plugins =
> [ :exception_notification, :ssl_requirement, :all ]
>
> # Skip frameworks you're not going to use. To use Rails without a
> database,
> # you must remove the Active Record framework.
> # config.frameworks -=
> [ :active_record, :active_resource, :action_mailer ]
>
> # Activate observers that should always be running
> # config.active_record.observers
> = :cacher, :garbage_collector, :forum_observer
>
> # Set Time.zone default to the specified zone and make Active Record
> auto-convert to this zone.
> # Run "rake -D time" for a list of tasks for finding time zone
> names.
> config.time_zone = 'UTC'
>
> # The default locale is :en and all translations from config/locales/
> *.rb,yml are auto loaded.
> # config.i18n.load_path += Dir[Rails.root.join('my', 'locales', '*.
> {rb,yml}')]
> # config.i18n.default_locale = :de
> end
>
> Please guys I already know how to use mysql syntax to "talk" to a
> database, I just don't know how to "tell" ruby to use mysql instead of
> sqlite3.
>
> Thanks
>
> On Aug 7, 3:54 pm, Marnen Laibow-Koser <rails-mailing-l...@andreas-
>
> s.net> wrote:
> > WalT wrote:
> > > 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.
>
> > No, he means the directory where mySQL is installed.
>
> > > 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.
>
> > This has nothing to do with Rails. It's a basic Windows (and Un*x)
> > concept. Go learn about it; this is elementary and you need to know.
>
> > > 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)
>
> > That won't help. The mySQL server is not a Ruby script.
>
> > (But in my opinion, you shouldn't use mySQL. PostgreSQL is a much
> > better database server. For most projects, there is no reason at all to
> > even consider mySQL.)
>
> > Best,
> > --
> > Marnen Laibow-Koserhttp://www.marnen.org
> > [email protected]
> > --
> > Posted viahttp://www.ruby-forum.com/.
>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
