If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.
Limits on Table size : The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive.
If you do encounter a full-table error, there are several reasons why it might have occurred:
- The disk might be full.
- The InnoDB storage engine maintains InnoDB tables within a tablespace that can be created from several files. This enables a table to exceed the maximum individual file size , check InnoDB tablespace (ibdata1)
- You are using MyISAM tables on an operating …