On Thu, 4 Sep 2003, Keith Bussey wrote: > Running that shows me the following: > > mysql> SHOW TABLE STATUS FROM email_tracking LIKE 'email_body_old'; > +----------------+--------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------+ > | Name | Type | Row_format | Rows | Avg_row_length | Data_length | > Max_data_length | Index_length | Data_free > | Auto_increment | Create_time | Update_time | Check_time > | Create_options | Comment | > +----------------+--------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------+ > | email_body_old | MyISAM | Dynamic | 208853 | 20564 | 4294967292 | > 4294967295 | 1820672 | 0 > | 450438 | 2002-10-21 11:58:24 | 2003-08-31 01:01:41 | 2002-11-30 > 01:41:00 | | | > +----------------+--------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------+ > 1 row in set (0.00 sec)
There's your problem... your 3 bytes off your max_data_length .. which is giving the table full error.... Check: http://www.mysql.com/doc/en/Full_table.html at the bottom for help to alter table to keep growing.... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
