mysql: alter table capacity

got a 'table is full' error in mysql? that means you've reached the size limit for a table.
you can solve this by deleting data from your table or adjusting your table's capacity.

here's how to adjust your table's capacity:

1. take a look at your table's status
mysql> show table status like '<table name>' \G

2. adjust your max_data_length, which is currently set to 4GB
mysql> alter table <table_name> max_rows = 200000000000;

now, take a look at your table's status again and see that your max_data_length changed

if want to go the other way, i know you know how to delete data by yourself ;)