I also had table is full error, today actually. mysql> alter table mytable max_rows = 200000000000 avg_row_length=50;
mysql> show table status like 'mytable' \G *************************** 1. row *************************** Name: mytable Type: MyISAM Row_format: Dynamic Rows: 157 Avg_row_length: 2257832 Data_length: 354479668 Max_data_length: 1099511627775 Index_length: 3072 Data_free: 0 Auto_increment: NULL Create_time: 2003-09-04 12:17:56 Update_time: 2003-09-04 12:18:09 Check_time: NULL Create_options: max_rows=4294967295 avg_row_length=50 Comment: 1 row in set (0.03 sec) this fixed my problem. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]