Undifined method rows for nill:Class when migrating my database using mysql2 gem

Every time i do rake db:migrate i get an error saying "undefined method "rows" for nill:Class". I am using the mysql2 gem on my windows machine开发者_高级运维 and have installed mysql v-5.5.13. Sqlite3 works very fine when i migrate but mysql does not. it only creates the database and creats the first table but when it wants to finish the migration of the first table i get the error. Any help?

I figured out how to solve the problem by:

gem install mysql2 -- '--with-mysql-lib="c:\Program Files\MySQL\MySQL Server 5.5\lib" --with-mysql-include="c:\Program Files\MySQL\MySQL Server 5.5\include"'

JUST to suit your need if you are having the same problem