ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn;
I used 300 for my AVG_ROW_LENGTH because I calculated my average to be about 260 bytes/row. YMMV
*WARNING* if you are doing this because the table is too big.. THIS WILL TAKE A LONG TIME.. COULD BE HOURS. during this time you will be able to query the table, but *NOT* update records.
Replys: