Chances are that if you are dealing with adding really large amounts of data into a MySQL table, you might encounter the infamous table is full error. According to the official MySQL reference manual, MySQL tables (MYISAM only) have size limits and these limits are determined by OS constraints.
For Win32 w/ FAT/FAT32 Systems (and other 32 Bit Systems) the limit is 2GB/4GB. It may sound like a lot, but trust me, it does not take long before you have used up the space and see that message on the screen.
After looking for a solution, I came across this site. Thanks Jeremy!
One of the fixes suggested is just a simple ‘ALTER TABLE’ command.
ALTER TABLE <TABLE_NAME> max_rows = 200000000000 avg_row_length = 50;
(Just note, that there will still be a limit when this is done, but this definitely buys you a lot more time :))
Have a read through the blog post, there are some other useful tips, like making this change while creating the table if you know you will be dealing with large amounts of data….or use InnoDB tables instead ![]()