Error running migration


#1

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:inconnect’
/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:innew’
/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:insend’
/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:incheckout_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:inloop’
/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:insynchronize’
/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:inconnection’
/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:inretrieve_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:ininitialize’
/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:inup’
/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:incall’
/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:ineach’
/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:ininvoke_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:ininvoke_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:ininvoke_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:ineach’
/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:instandard_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:inrun’
/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:inrun’
/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


#2

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