when running select count(distinct value) from table; on a table with more than 19 million records i got the error: got error 27 from table handler (or something like that)
i looked up the error in mysql perror which gave me "file too large" does this have to do with my file size in linux or a specific option in my.cnf ? Augey --------------------------------------------------------------------- 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