mysql 不支持load data_Mysql2 ::错误：此MySQL版本不允许使用命令：LOAD DATA LOCAL INFILE...

这是我的完整脚本.

我试图做一个rake任务,从目录中的文件收集数据并将它们加载到mysql中.

我修复了local-infile = 1,没什么用.它只是给我错误

namespace :db do

namespace :load do

desc "Load Properties into DB"

task :properties => :environment do

Mysql2::Client.default_query_options[:connect_flags] |= Mysql2::Client::LOCAL_FILES

@files = Dir.entries("db/property_website_scripts/")

connection = ActiveRecord::Base.connection()

for file in @files

next if file == "." || file == ".."

sql = "LOAD DATA LOCAL INFILE '#{Rails.root}/db/property_website_scripts/#{file}'

INTO TABLE properties

FIELDS TERMINATED BY '|'

LINES TERMINATED BY '\r\n'

(property_type,property_for,city,state,country......);"

connection.execute(sql)

end

#updating created at and updated at

Property.update_all({:created_at => Time.now,:updated_at => Time.now},"created_at IS NULL")

end

end

end