You need to change the "maxrows" on the table. It is in the documentation, I
dont remember the exact syntax something like "alter table tablename set
maxrows=100000000" for tables larger than 2gigs.
ryan
> I've got tables in ISAM format whose indexes are way over 64 MB. However,
> when I try to create a MyISAM table with an index that big I get errors
and
> confirming that with myisamchk I get:
>
> myisamchk: warning: Keyfile is almost full, 67107839 of 67107839 used
>
> Which is essentially 64MB. Are MyISAM tables able to handle large
indexes?
> I hope I don't have to go back to ISAM tables...
> Any suggestions?
>
> Thanks,
> Jeff Brewer
>
> Spam filter bypass: (database,sql,query)
>
>
> ---------------------------------------------------------------------
> 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
