I have checked my file size in my data dir and can't find any files 
close to 2GB even looking in subdirs.  

Does this mean that my problem is most likely corruption or could it 
still be "file too large".

Augey



Augey Mikus wrote:

> 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
>
>




---------------------------------------------------------------------
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

Reply via email to