Forum: RForum Rake Error/SQL

Posted by Paul Cote (megspaul)
on 2007-04-17 08:00
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    <DIR>          .
04/16/2007  08:06 AM    <DIR>          ..
04/16/2007  08:06 AM    <DIR>          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    <DIR>          .
04/16/2007  10:52 PM    <DIR>          ..
04/16/2007  10:52 PM    <DIR>          music_library
04/16/2007  08:06 AM    <DIR>          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>
Please log in before posting. Registration is free and takes only a minute.
Existing account (Switch to SSL-encrypted connection)
NEW: Do you have a Google/GoogleMail or Yahoo account? No registration required!
Log in with Google account | Log in with Yahoo account
No account? Register here.