cat /etc/passwd on my Macintosh 10.3 at work (I'm using Linux at home) shows me this for
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