Ruby MySQL 2.7.3 Gem – Error doing db:migrate

I have recently upgraded the MySQL gem to resolve ‘lost connection’ issues all appeared to work (I’m using MySQL v5 on XP running MySQL as a service). However this evening I needed to do some database migration which presented me with an error
“The procedure entry point mysql_stmt_row_tell could not be located in
the dynamic link library LIBMYSQL.dll.”

I have ‘goggled’ this but nothing out there to explain the reason. I did however check the state of the database and it has been migrated correctly. I shall be monitoring it going forward, if you have a solution please comment. Updates will be added to this post when I find the solution.

Update
Fixed: Added the path to the MySQL bin directory
C:\Program Files\MySQL\MySQL Server 5.0\bin

This entry was posted in Ruby On Rails and tagged . Bookmark the permalink.
  • Anonymous

    I’m getting the same error. To what did you add the path to MySQL bin? Did you add it to the Windows path, or in your app?

  • Andrew Woodward

    From memory and this was a long time ago, I added this to the Windows Path

  • http://www.mysecuremovers.com/ boston moving help

    This is already a year ago and I just want to say that I also got the same error before. Anyway thanks for posting this one.