I am very new to ROR’s. I am taking an SQL class and installed MySQL
previously, and just installed ROR’s last night. I am following some of
the essential training on lynda.com and got stuck trying to do the
database. Do I need to change something in the MySQL? I have a command
prompt already for MySQL. I was not able to create the databse via reg
command prompt, but did in the MySQL prompt. Below is what I did, so
maybe someone can give me some hinters?
Thanks
C:\Documents and Settings\PAUL\Sites>dir
Volume in drive C has no label.
Volume Serial Number is E87D-1604
Directory of C:\Documents and Settings\PAUL\Sites
04/16/2007 08:06 AM .
04/16/2007 08:06 AM …
04/16/2007 08:06 AM my_app
0 File(s) 0 bytes
3 Dir(s) 50,147,160,064 bytes free
C:\Documents and Settings\PAUL\Sites>rails music_library
create
create app/controllers
create app/helpers
create app/models
create app/views/layouts
create config/environments
create components
create db
create doc
create lib
create lib/tasks
create log
create public/images
create public/javascripts
create public/stylesheets
create script/performance
create script/process
create test/fixtures
create test/functional
create test/integration
create test/mocks/development
create test/mocks/test
create test/unit
create vendor
create vendor/plugins
create tmp/sessions
create tmp/sockets
create tmp/cache
create tmp/pids
create Rakefile
create README
create app/controllers/application.rb
create app/helpers/application_helper.rb
create test/test_helper.rb
create config/database.yml
create config/routes.rb
create public/.htaccess
create config/boot.rb
create config/environment.rb
create config/environments/production.rb
create config/environments/development.rb
create config/environments/test.rb
create script/about
create script/breakpointer
create script/console
create script/destroy
create script/generate
create script/performance/benchmarker
create script/performance/profiler
create script/process/reaper
create script/process/spawner
create script/process/inspector
create script/runner
create script/server
create script/plugin
create public/dispatch.rb
create public/dispatch.cgi
create public/dispatch.fcgi
create public/404.html
create public/500.html
create public/index.html
create public/favicon.ico
create public/robots.txt
create public/images/rails.png
create public/javascripts/prototype.js
create public/javascripts/effects.js
create public/javascripts/dragdrop.js
create public/javascripts/controls.js
create public/javascripts/application.js
create doc/README_FOR_APP
create log/server.log
create log/production.log
create log/development.log
create log/test.log
C:\Documents and Settings\PAUL\Sites>db:migrate
The filename, directory name, or volume label syntax is incorrect.
C:\Documents and Settings\PAUL\Sites>rake db:migrate
rake aborted!
No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb,
Rakefile.rb)
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:1849:in
`load_rakefile’
(See full trace by running task with --trace)
C:\Documents and Settings\PAUL\Sites>rakefile db:migrate
‘rakefile’ is not recognized as an internal or external command,
operable program or batch file.
C:\Documents and Settings\PAUL\Sites>rake db:migrate
rake aborted!
No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb,
Rakefile.rb)
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:1849:in
`load_rakefile’
(See full trace by running task with --trace)
C:\Documents and Settings\PAUL\Sites>cd \music_library
The system cannot find the path specified.
C:\Documents and Settings\PAUL\Sites>dir
Volume in drive C has no label.
Volume Serial Number is E87D-1604
Directory of C:\Documents and Settings\PAUL\Sites
04/16/2007 10:52 PM .
04/16/2007 10:52 PM …
04/16/2007 10:52 PM music_library
04/16/2007 08:06 AM my_app
0 File(s) 0 bytes
4 Dir(s) 50,144,333,824 bytes free
C:\Documents and Settings\PAUL\Sites>cd \music_library
The system cannot find the path specified.
C:\Documents and Settings\PAUL\Sites>cd /music_library
C:\Documents and Settings\PAUL\Sites\music_library>rake db:migrate
(in C:/Documents and Settings/PAUL/Sites/music_library)
rake aborted!
#42000Unknown database ‘music_library_development’
(See full trace by running task with --trace)
C:\Documents and Settings\PAUL\Sites\music_library>–trace
‘–trace’ is not recognized as an internal or external command,
operable program or batch file.
C:\Documents and Settings\PAUL\Sites\music_library>–trace)
‘–trace)’ is not recognized as an internal or external command,
operable program or batch file.
C:\Documents and Settings\PAUL\Sites\music_library>rake db:migrate
–trace
(in C:/Documents and Settings/PAUL/Sites/music_library)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
#42000Unknown database ‘music_library_development’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/vendor/mysq
l.rb:523:in read' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/vendor/mysq l.rb:153:in real_connect’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_
adapters/mysql_adapter.rb:389:in connect' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_ adapters/mysql_adapter.rb:152:in initialize’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_
adapters/mysql_adapter.rb:82:in new' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_ adapters/mysql_adapter.rb:82:in mysql_connection’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_
adapters/abstract/connection_specification.rb:262:in send' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_ adapters/abstract/connection_specification.rb:262:in connection_without_query_c
ache=’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/query_cache
.rb:54:in connection=' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_ adapters/abstract/connection_specification.rb:230:in retrieve_connection’
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_
adapters/abstract/connection_specification.rb:78:in connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.r b:284:in migrate’
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/databases.rake:4
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in call' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in execute’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in each' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:399:in execute’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:369:in invoke' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:362:in synchronize’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:362:in invoke' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:1935:in run’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:1935:in each' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/lib/rake.rb:1935:in run’
c:/ruby/lib/ruby/gems/1.8/gems/rake-0.7.2/bin/rake:7
c:/ruby/bin/rake.bat:20:in `load’
c:/ruby/bin/rake.bat:20
C:\Documents and Settings\PAUL\Sites\music_library>