Re: Can not write to a file in /home/.....
chown -R mysql:mysql /home/medic/ and make sure there is no outfile.txt already in that dir. --- sam <[EMAIL PROTECTED]> wrote: > I executed the following statement: > > SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM > fool; > > I get the error meassge > > " Can't create/write to file > '/home/medic/outfile.txt' (Errcode:13) " > > I followed the solutions from the manual "A.3.3 > Problems with File > Permissions" > and still have a problem. > > I created a my.cnf and when I put in the line: > set-varibale = UMASK=0777 in the {mysqld} section - > the deamon will not > start. > > I created a script as follows: > > UMASK=0777 > export UMASK > UMASK_DIR=0777 > export UMASK_DIR > etc/bin/safe_mysqld & > > Can anyone help > > sam, > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can not write to a file in /home/.....
Did you also check directory permissions? What system are you using? Chuck http://68.43.100.7:81/aa8vs == "Patriotism is the willingness to kill and be killed for trivial reasons." - Bertran Russell -Original Message- From: sam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 5:51 PM To: MySQL List Subject: Re: Can not write to a file in /home/. I executed the following statement: SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM fool; I get the error meassge " Can't create/write to file '/home/medic/outfile.txt' (Errcode:13) " I followed the solutions from the manual "A.3.3 Problems with File Permissions" and still have a problem. I created a my.cnf and when I put in the line: set-varibale = UMASK=0777 in the {mysqld} section - the deamon will not start. I created a script as follows: UMASK=0777 export UMASK UMASK_DIR=0777 export UMASK_DIR etc/bin/safe_mysqld & Can anyone help sam, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can not write to a file in /home/.....
I executed the following statement: SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM fool; I get the error meassge " Can't create/write to file '/home/medic/outfile.txt' (Errcode:13) " I followed the solutions from the manual "A.3.3 Problems with File Permissions" and still have a problem. I created a my.cnf and when I put in the line: set-varibale = UMASK=0777 in the {mysqld} section - the deamon will not start. I created a script as follows: UMASK=0777 export UMASK UMASK_DIR=0777 export UMASK_DIR etc/bin/safe_mysqld & Can anyone help sam, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php