Have you checked that /tmp isn't full? If /tmp is its own filesystem, and its full, then no matter what the permissions you won't be able to write to it.
At 10:24 PM 10/2/01 +0200, you wrote: >When execcuting some queries in MySQL (3.23.42) on Redhat 7.1 i'v got >error: >ERROR 1: Can't create/write to file >'/tmp/root-tmp.03a811f23b28d045/files/#sql61ba_d_0.MYI' (Errcode: 2) > >/tmp dir permission is 777 so there shouldn't be problem. When i create dir >which mysql wants to write to everything is ok. >MySQL server, works as mysql user. >What's wrong? >By the way, should mysql create tmpdir as root-tmp, not mysql-tmp ? > > >--------------------------------------------------------------------- >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
