MySQL restore prompt "The table ' TABLENAME ' is full"

Solution: Show create table TABLENAME; Know engine type is memory;

VIM/ETC/MYSQL/MY.CF Add/Modify two lines under [mysqld] (if not, you can increase the value):

Tmp_table_size = 256M

Max_heap_table_size = 256M

Service MySQL Restart

Reason: Because the engine type of the table is memory, there is max_heap_table_size limit in MySQL memory engine, the data is a little more full.

Reference: http://www.cnblogs.com/ccdc/p/4119465.html

http://blog.csdn.net/kevon_sun/article/details/7967728

This article is from the "linuxtips" blog, make sure to keep this source http://linuxtips.blog.51cto.com/11213600/1773930

MySQL restore prompt "The table ' TABLENAME ' is full"