LOAD DATA LOCAL / "out of range" error

Rails
1

Hi All.

I have a tabbed delimited text file which I would like to load via
ActiveRecord::Base.connection.execute(“LOAD DATA LOCAL INFILE…”)

However, I get the following error message:

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/
active_record/connection_adapters/abstract_adapter.rb:120:
in `log’: Mysql::Error: #42000The used command is not allowed with this
MySQL version:
LOAD DATA LOCAL INFILE ‘C:/Rails/music/app/songs.txt’ INTO TABLE
music.songs; (ActiveRecord::StatementInvalid)

I assume that since LOAD DATA LOCAL has security issues, the default
setting must disable that statement.

I have tried it without “LOCAL”, but I get “out of range value” errors,
which I would like to ignore. (This occurs at an autoincremented column
for which I used “\n”, per MySQL manual)

My question is this: How can I execute a "LOAD DATA LOCAL " statement?
An alternate question is “How can I avoid out of range error?”

2

lisa-u wrote:

I assume that since LOAD DATA LOCAL has security issues, the default
setting must disable that statement.

My question is this: How can I execute a "LOAD DATA LOCAL " statement?

More accurately, how can I change the setting in Rails to allow for this
action?
The statement works fine in my Java program as well as in the MySQL
Query Browser