It might be that the Rails version is using the mysql adapter that comes with Rails, which is a pure Ruby implementation that has a maximum limit to the number of bytes it can ship over the wire.
This problem has come up a couple of times, so I finally pulled the content from emails I had sent to individuals and posted in on my blog: http://anthonyeden.com/2007/12/20/mysql-bulk-load-with-pure-mysql-driver-in-rails V/r Anthony Eden On 12/20/07, Brandon Dimcheff <[EMAIL PROTECTED]> wrote: > I'm trying to add a couple features to the the adapter extensions, but > I can't seem to get a few of the tests to run. For instance, > test_bulk_load throws: > > Mysql::Error: The used command is not allowed with this MySQL version: > LOAD DATA LOCAL INFILE './test/integration/people.txt' INTO TABLE people > > According to pretty much whatever I've read, this is caused by local- > infile being disabled on either the client or server side. I can run > the query in the mysql command line client, so it must be something > fishy with ActiveRecord. The strange thing is, I can run that same > query in script/console in my activewarehouse-based project and it > executes just fine. I just can't seem to figure out what's different > about the way ActiveRecord is being used in these tests vs. in a rails > app... > > Any ideas? > > Thanks, > Brandon > _______________________________________________ > Activewarehouse-discuss mailing list > Activewarehouse-discuss@rubyforge.org > http://rubyforge.org/mailman/listinfo/activewarehouse-discuss > _______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
