Thanks I will make new tables and transfer the data over =) Just wodnering though, any advice on how to tell what to set AVG_ROW_LENGTH to ?
-- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting [EMAIL PROTECTED]: > > 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]
