On 4 Sep 2003 at 10:13, Keith Bussey wrote:
> -rw-rw---- 1 mysql mysql 4.0G Aug 31 01:01 email_body.MYD
>
> Thus if I try and insert one more row I get the error:
>
> ERROR 1114: The table 'email_body' is full
By default, MyISAM tables use 4-byte pointers to indicate positions
in the data file. So if your data file gets bigger than 4 GB (or
larger for fixed-length records, but that's not what you have), you
get that error:
http://www.mysql.com/doc/en/Full_table.html
Figure out how many records you're likely to need and do
ALTER TABLE email_body MAX_ROWS=<whatever>;
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
