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@lists.mysql.com > 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/[EMAIL PROTECTED]
