Beginner Facing Problem with rake db:migrate

I am beginner for this Rails from the past 2 days I am working hard to fix the following error

C:\Murali Rubby\demo\library>rake db:migrate --trace (in C:/Murali Rubby/demo/library) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate == CreateBooks: migrating

It looks like your mysql database already has a 'books' table. So either manually reset the database (and the schema) or run the appropriate rake tasks to undo what you've done...

If you don't care about any of the data in there you could do

rake db:drop db:create db:migrate

to get back to this point... type "rake -T db" to see your other options

Hi Philip,

Earlier I manual dropped all the tables that didn't fix the problem Now used rake db:drop db:create db:migrate but still geting rake aborted message..

C:\Murali Rubby\demo\library>rake db:drop db:create db:migrate

(in C:/Murali Rubby/demo/library) rake aborted! Mysql::Error: Specified key was too long; max key length is 767 bytes: CREATE UN IQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)

(See full trace by running task with --trace)

So please provide some other Info to fix that...

Thank you so much for your quick reply.

Heh. Google for your mysql error and you'll find this thread which is *exactly* the same problem... even down to the same tables...

Good luck!