Ngan

Here's a patch that I did in my Rails app to fix this:

module ActiveRecord
  module ConnectionAdapters
    class MysqlAdapter
    private
      def connect_wit...

Is this happening for anyone else?

Awesome! I confirmed that it fixed it for me as well. Any case someone can make a patch for this?

Jonathan, do update on how it goes with mysql2.

Thanks!

I'm using Rails 2.3.8, so it's on the mysql gem (not mysql2). I've also updated to the latest gem version of mysql, and still get the same problem.

I've gone through all the MySQL documentation and made sure everything has permissions. You'll notice in my console output, the first I do the LOAD DATA LOCAL I...

Actual console output

ruby-1.8.6-p399 :003 > ActiveRecord::Base.connection.execute("LOAD DATA LOCAL INFILE '/tmp/test.infile' INTO TABLE users")
[Sat Jan 08 00...


> ActiveRecord::Base.connection.disconnect! > ActiveRecord::Base.verify_active_connections! > ActiveRecord::Base.connection.execute("LOAD DATA INFILE '/tmp/som...

Hi, I'm on Rails 2.3.8, but I think this problem affects Rails 3.x as well.

After using ActiveRecord::Base.verify_active_connections! after the mysql going away...