SELECT INTO OUTFILE can't write to file

mysql sql linux into-outfile
Jason Swett picture Jason Swett · Nov 22, 2010 · Viewed 41.6k times · Source

I'm trying to do a SELECT INTO OUTFILE and I'm getting the following error:

General error: 1 Can't create/write to file '/home/jason/projects/mcif/web/downloads/dump.csv' (Errcode: 13). Failing Query: "
SELECT name
INTO OUTFILE '/home/jason/projects/mcif/web/downloads/dump.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
FROM account a

I know what the problem probably is: my downloads folder isn't writable by my MySQL user. I don't know how to solve this problem for two reasons:

  • I don't know how to find out what the MySQL user is
  • I don't know how to add the MySQL user to the users who are able to write to the downloads folder

I'm on Ubuntu Linux. Can someone help me get past those two things?

Answer

Doon picture Doon · Nov 22, 2010

write the file /tmp/dump.csv and the copy it over.. That will let you see who is running what. My guess is that you are doing this from the web and the client is running as the web server process...

Related questions

Linux alternatives to Sequel Pro? (GUI based sql navigator)

Anyone have any suggestions? Running Debian and looking for a good alternative.

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More