Hello.


You may specify location of temp files with 'tmpdir' server system variable.

See:

  http://dev.mysql.com/doc/mysql/en/Temporary_files.html

  http://dev.mysql.com/doc/mysql/en/Server_system_variables.html





Gail Lange <[EMAIL PROTECTED]> wrote:

> Hello

>    I have just installed mysql 4.1.7 on Mandrake 10.0 (final).

> All went smoothly.

>     However, when I issue the following command:

>                           /usr/local/mysql/bin/mysqld_safe --user=mysql &

> I get the error:

>           Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13)

> When I examine the error file in /usr/local/mysql/var it says it cannto 

> read /root and it

> cannot write to /root/tmp

>         If I give others (beside root) r permission to /root and rw 

> permissions to /root/tmp,

> it start up fine.

>        I have looked as startup options for the mysqld_safe as well as 

> the /etc/my.cnf file but have not found anyway to alter where it wants 

> to write its temp files.

> 

>       Can anyone please help?

> Thanks,

>        Gail

> 

> 

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to