Rake db:migrate error .. please help

Rails Deployment
1

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 ??

2

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

3

Andola S. 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&p=27407&hilit=libmysql.dll#p27407

-sunny
http://ezror.com