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