MySQL memmory table import “the table is full”

Question

I'm trying to import a dumped memmory table (created with mysqldump) on an new machine. (for replication). It fails with the error message:

the table is full

As far as I can tell, all relevant settings (including max_heap_table_size) are equal on both the source and destination server.

Are there any more know issues/settings I need that can cause the above error?

Answer 1

There are a few questions to be asked:

1. Are the tables dumped and imported defined identically?
2. Do you have an indexes on the table you are importing?

I would think that the simplest solution might be increasing the max_heap_table_size value in the configuration and once you finish the import compare the size of the table data.