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 'rn'
               (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

将其添加到database.yml

local_infile：true

（编辑：台州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!