Forum: Rails deployment rake db:migrate error .. please help

I'm really new to ruby on rails and all of this.

I'm using mysql as a database server and i created a database with the
name music_library_development, with a table in it.

Then i edit the database.yml file accordingly for mysql.
  adapter: mysql
  database: music_library_development
  username: root
  password: password
  host: localhost

after saving i go to the command prompt and inside the project folder
and type rake db:migrate..

i get the following error:-

rake aborted!
Mysql::Error: query: not connected: CREATE TABLE 'schema_migrations'
('version' varchar(255) NOT NULL) ENGINE=InnoDB

whats going wrong ??

you should first create the database before migrating it. use "rake 
db:create" first and then migrate it. it should work..

Andola Soft wrote in post #949498:
> you should first create the database before migrating it. use "rake
> db:create" first and then migrate it. it should work..

I was going to say that, but he mentions he did create it manually.

After a bit of googling, I found this post which seemed to have helped 
others with this problem: 
http://forums.aptana.com/viewtopic.php?f=20&t=7563...

-sunny
http://ezror.com