Re: Can not write to a file in /home/.....

2002-12-17 Thread Qunfeng Dong
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/.....

2002-12-17 Thread Charles Mabbott
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/.....

2002-12-17 Thread sam
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