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]