Pull for issue #233 take two - #242

@sodabrew thank you so much for taking the time to research and package this!

@brianmario I can confirm this pull request allowed me to achieve bulk load while using Mysql2::Client.default_query_options[:connect_flags] |= Mysql2::Client::LOCAL_FILES did not work for me (packet errors).

This changeset refactors the mysql_options calls to reduce code duplicate, and adds one more option, :local_infile (which would have been a lot of duplicated code until I refactored it).

The new option is used like this:
@mysql = Mysql2::Client.new(:host => @host, :username => @username, :database => @Schema, :local_infile => true)

could you update or resubmit this so it's mergable?

Merged your latest code, the one conflict was trivial whitespace at the end of the file ext/mysql2/client.h

Thanks for looking into my pull! Much appreciated!

Related: http://stackoverflow.com/questions/8790874/load-data-local-infile-causes-malformed-packet-error-with-mysql2-gem

Question on this one for Rails 3.0.x compatibility (which I try to achieve in adapter_extensions): if this one get merged, will there be a release of mysql2 < 0.3 including the fix?

Yeah I try to push out releases for 0.2.x as well as 0.3.x

Great to hear :) thanks!

Just wanted to say that we switched to this fork of mysql2 and it has resolved our local_infile issues as described in greater detail in #43 . Looking forward to mysql2 pulling it in!

sodabrew, thank you for this one. We forked brianmario, and merged this pull in, and our issues have been resolved as well.

Cool. I've been pretty busy recently, but per Brian's request I'm going to work on adding some more unit tests to make sure this patch is good to go upstream.

I cleaned up the code and moved it to a branch. Can't see where to change the branch in this pull request (probably because it has comments on it already?) so I'll open a new pull request.

(See pull request #252 now.)