Can not write to a file in /home/..... the deamon will not start.

Is the following a bug or me.

How-to-repeat :

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 &




------------------------------------------------------------ ---------
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 bugs-thread13325@lists.mysql.com
To unsubscribe, e-mail

Re: Can not write to a file in /home/..... the deamon will not start.

sam writes:
> Is the following a bug or me.
>
> How-to-repeat :
>
> 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 &
>
>

UMASK will not help you here.

If you run MySQL server as uid of user mysql, then it can not be
done. User mysql does not have privileges to write to directory
/home/medic.

Use /tmp instead.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
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 bugs-thread13329@lists.mysql.com
To unsubscribe, e-mail