Forum: Ruby on Rails Error running migration

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Virendra N. (Guest)
on 2009-05-25 09:16
Hello
 I generate a scaffold for the User it created a migration for me for
user table
 now when iam trying to run that migration its give me a error
 a ran the migration command with --trace to crack down the source of
the error
 but it should me this bunch of things and its not getting to my head


** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
Unknown database '[my_database_name]_development'

/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/mysql_adapter.rb:576:in
`real_connect'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/mysql_adapter.rb:576:in
`connect'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/mysql_adapter.rb:204:in
`initialize'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/mysql_adapter.rb:76:in
`new'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/mysql_adapter.rb:76:in
`mysql_connection'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in
`send'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in
`new_connection'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in
`checkout_new_connection'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in
`checkout'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
`loop'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
`checkout'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/1.8/monitor.rb:238:in `synchronize'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in
`checkout'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in
`connection'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in
`retrieve_connection'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in
`retrieve_connection'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in
`connection'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:435:in
`initialize'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:400:in
`new'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:400:in
`up'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:383:in
`migrate'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/tasks/databases.rake:116
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:617:in
`call'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:617:in
`execute'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:612:in
`each'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:612:in
`execute'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:578:in
`invoke_with_call_chain'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/1.8/monitor.rb:238:in `synchronize'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:571:in
`invoke_with_call_chain'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:564:in
`invoke'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2027:in
`invoke_task'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in
`top_level'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in
`each'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2005:in
`top_level'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2044:in
`standard_exception_handling'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1999:in
`top_level'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1977:in
`run'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:2044:in
`standard_exception_handling'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/lib/rake.rb:1974:in
`run'
/PROGRA~1/BITNAM~1/ruby/lib/ruby/gems/1.8/gems/rake-0.8.4/bin/rake:31
/PROGRA~1/BITNAM~1/ruby/bin/rake:19:in `load'
/PROGRA~1/BITNAM~1/ruby/bin/rake:


any idea
thank anyway
Rick L. (Guest)
on 2009-05-25 09:29
(Received via mailing list)
This says it all: Unknown database '[my_database_name]_development'

Before you can migrate your new table you need to create the
database.  Evidently you are set up to use mysql.  If you check the
file config/database.yml you will see something like:

development:
  adapter: mysql
  encoding: utf8
  reconnect: false
  database: testmysql_development
  pool: 5
  username: root
  password:
  socket: /tmp/mysql.sock

where "testmysql" will be the name of your project
("my_database_name"?).  You will need to create a database with
"YOUR_PROJECT_NAME_development" that can be accessed by the user
identified by "username:" and "password:".  Then you can run rake
db:migrate.


On May 24, 7:16 pm, Virendra N. <removed_email_address@domain.invalid>
This topic is locked and can not be replied to.