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]

Reply via email to