I had an errcode 28, so redirected the tmpdir to my /home directory. Now I'm getting another error. I don't know if this is Linux or MySQL?? mysql> select count(*),state from import_talents group by state; ERROR 3: Error writing file '/home/tempspace/MYfZExbS' (Errcode: 122) Error 122 tells me that the USER LIMIT has been reached. (I'm on a Redhat Linux system). Well, let's check what the limit is: [root@www]$ ulimit unlimited Maybe the mysql has a limit? [root@www /]# su mysql [mysql@www /]$ ulimit unlimited Where is this thing hitting the wall? Thank you, Richard --------------------------------------------------------------------- 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
