使用SELECT INTO OUTFILE如何解决MySQL Errcode 13？(How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?)

 我试图使用MySQL SELECT INTO OUTFILE语句将表的内容转储到csv文件。 如果我做： 
 
SELECT column1, column2
INTO OUTFILE 'outfile.csv'
FIELDS TERMINATED BY ','
FROM table_name;
 
 outfile.csv将在该数据库文件所在的同一目录中的服务器上创建。 
 
 但是，当我将查询更改为： 
 
SELECT column1, column2
INTO OUTFILE '/data/outfile.csv'
FIELDS TERMINATED BY ','
FROM table_name;
 
 我得到： 
 
ERROR 1 (HY000): Can't create/write to file '/data/outfile.csv' (Errcode: 13)
 
 Errcode 13是一个权限错误，但是即使我将/ data的所有权更改为mysql：mysql并给它777权限，我也得到它。 MySQL作为用户“mysql”运行。 
 
 奇怪的是，我可以在/ tmp中创建文件，只是在我尝试过的任何其他目录中，即使有权限设置，使得用户的mysql应该能够写入目录。 
 
 这是在Ubuntu上运行的MySQL 5.0.75。 

I am trying to dump the contents of a table to a csv file using a MySQL SELECT INTO OUTFILE statement. If I do:
 
SELECT column1, column2
INTO OUTFILE 'outfile.csv'
FIELDS TERMINATED BY ','
FROM table_name;
 
outfile.csv will be created on the server in the same directory this database's files are stored in. 
 
However, when I change my query to:
 
SELECT column1, column2
INTO OUTFILE '/data/outfile.csv'
FIELDS TERMINATED BY ','
FROM table_name;
 
I get:
 
ERROR 1 (HY000): Can't create/write to file '/data/outfile.csv' (Errcode: 13)
 
Errcode 13 is a permissions error, but I get it even if I change ownership of /data to mysql:mysql and give it 777 permissions. MySQL is running as user "mysql".
 
Strangely I can create the file in /tmp, just not in any other directory I've tried, even with permissions set such that user mysql should be able to write to the directory.
 
This is MySQL 5.0.75 running on Ubuntu. 

原文：https://stackoverflow.com/questions/2783313