MySql OUTFILE 在 rails 3 中不起作用

Question

在我的一个 Rails 操作中，我想使用 MySql OUTFILE 从表创建一个 csv 文件。

path = "#{Rails.root}/public/outfile.csv"
query_string = "SELECT * INTO OUTFILE '#{path}' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' FROM temp_csv_186;"
ActiveRecord::Base.connection.execute(query_string)

但每次都显示错误。

Mysql2::Error: Can't create/write to file '/home/user/Projects/Application/public/outfile.csv' (Errcode: 13): SELECT * INTO OUTFILE '/home/user/Projects/Application/public/outfile.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' FROM temp_csv_186;

Answer 1

Mysql 在哪个用户下运行是否获得了/home/user/Projects/Application/public/的写权限？