List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:April 27 2007 3:49pm
Subject:RE: Permissions and Into Outfile
View as plain text  
Another variant would be, to create a directory under your
www area, and give it <your-user>:mysql 775 permissions, or
maybe <web-server-user>:mysql 775 permissions, depending
on what you want to do with the csv file.

On Fri, April 27, 2007 16:41, Kebbel, John wrote:
> cat /etc/passwd on my Macintosh 10.3 at work (I'm using Linux at home)
> shows me this for mysql ...
>
> mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false
> The home directory for mysql is /var/empty, which does exist. Should I
> write ~into  file~ output to this folder or should I change the mysql home
> directory to some other folder?
>
>> ----------
>> From: 	Gerald L. Clark
>> Sent: 	Friday, April 27, 2007 10:09 AM
>> To: 	Kebbel, John
>> Cc: 	mysql@stripped
>> Subject: 	Re: Permissions and Into Outfile
>>
>> Kebbel, John wrote:
>> > 	I was trying to write the output of a select statement to a
>> tab-delimited text file. I  could not write the file to a folder
>> inside /var/www or to my home file because of permission problems.
>> After a moment's reflection, I realized /tmp had stuff written to it
>> all the time, so its permissions must be wide open. I tried writing
>> the file to /tmp and it worked fine. Since you cannot write to an
>> existing file, you cannot create the file in advance and set its
>> permissions. What is the trick to getting the file to write
>> successfully anywhere you want it to be written?
>> >
>> > 	This is the query I was using...
>> >
>> > mysql> select sched_students.id, firstName, lastName, grade, race,
>> gender, dob, school, phone, program, hsMath, hsEnglish, hsScience,
>> major, 9YBand, 9YChorus, 9YGifted, 9YTV, 9YROTC, 9YSpanishI,
>> 9YSpanish2, 9YFrenchI, 9SAerobics, 9SArt, 9SBasketball, 9SDrama,
>> 9SDriverEd1, 9SDriverEd2, 9SRecreation, 9STeamSports1, 9STeamSports2,
>> 9SWeights
>> > 			into outfile '/tmp/srhs9.txt'
>> >
>> > from sched_students, SCHED_COURSES where (sched_students.id =
>> SCHED_COURSES.id) and (grade = 8) order by lastname, firstname;
>> >
>> The user 'mysql' must have write permission in the target directory.
>>
>> --
>> Gerald L. Clark
>> Supplier Systems Corporation
>>
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>
>


-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224



-- 
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

Thread
Permissions and Into OutfileJohn Kebbel27 Apr
  • Re: Permissions and Into OutfileGerald L. Clark27 Apr
    • RE: Permissions and Into OutfileJohn Kebbel27 Apr
      • Re: Permissions and Into OutfileGerald L. Clark27 Apr
      • RE: Permissions and Into OutfileMogens Melander27 Apr
RE: Permissions and Into OutfileJohn Kebbel28 Apr
  • RE: Permissions and Into OutfileMogens Melander28 Apr
RE: Permissions and Into OutfileJohn Kebbel28 Apr