• crain
  • Ticketholder
  • Offline
  • Registered: 2009-08-25
  • Posts: 2

Topic: MySQL Error: rake db:migrate

Hello guys,

i just tried to setup and migrate some objects in the MySQL DB with Ruby on Rails. If i am running "rake db:migrate" i getting the following error:

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

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

I am using MySql 5.1.37 and i already created a DB with rake db:create

Can you help me with this error message? Thanks a lot!
Mark

Last edited by crain (2009-08-25 13:28:20)

  • Registered: 2008-02-09
  • Posts: 3

Re: MySQL Error: rake db:migrate

Hey crain,

I am getting the exact same error.  If you wouldn't mind forwarding any proposed solutions (rob.smith05@gmail.com) it would be greatly appreciated...

rob

  • From: Sydney
  • Registered: 2007-07-13
  • Posts: 1,344

Re: MySQL Error: rake db:migrate

Or you could subscribe to this topic and they could be posted here and be of benefit to everyone. Just a thought ...

  • crain
  • Ticketholder
  • Offline
  • Registered: 2009-08-25
  • Posts: 2

Re: MySQL Error: rake db:migrate

Hi everybody,

i just found a hint on http://forums.aptana.com/viewtopic.php? … dll#p27407

And this works for me!

-Mark

  • Registered: 2008-02-09
  • Posts: 3

Re: MySQL Error: rake db:migrate

The proposed solution by crain worked for me as well.

Sorry, I didn't see the subscribe option when I posted the request.

Thanks all!

  • Registered: 2009-08-26
  • Posts: 3

Re: MySQL Error: rake db:migrate

Different Rails version needs different configuration.
So, never update your rails version without preparation.

  • From: Sydney
  • Registered: 2007-07-13
  • Posts: 1,344

Re: MySQL Error: rake db:migrate

viva_yang wrote:

Different Rails version needs different configuration.
So, never update your rails version without preparation.

No where does this thread mention an upgrade.

  • Registered: 2010-08-06
  • Posts: 1

Re: MySQL Error: rake db:migrate

Hi,

I faced the same issue now its solved.

Step -1 To get rid of the issue copyt the libmySQL.dll from this link

http://instantrails.rubyforge.org/svn/t … bmySQL.dll

Step -2 Paste iit in C:\Ruby\bin of yours

Reply to me ! If u get rid off :)
Thanks

  • Registered: 2010-12-22
  • Posts: 8

Re: MySQL Error: rake db:migrate

Thx Sundari,
It worked for me.....

  • Registered: 2010-12-28
  • Posts: 4

Re: MySQL Error: rake db:migrate

Thanks Sundari my problem is fixed now
_____________________
Make cash from residual income affiliate programs like health affiliate programs.

  • Registered: 2011-03-13
  • Posts: 1

Re: MySQL Error: rake db:migrate

Same here, Sundari's fix worked like a charm.

Thanks!

  • Registered: 2011-05-08
  • Posts: 2

Re: MySQL Error: rake db:migrate

thanks !! it works smile

  • Registered: 2011-11-13
  • Posts: 1

Re: MySQL Error: rake db:migrate

Thanks gsundari,
it worked for me too!!!

  • Registered: 2011-11-15
  • Posts: 3

Re: MySQL Error: rake db:migrate

the same problem,i tried gsundari's solution,but still not fixed,why?