title: Inserting data into memory table
body: <p>I have created a MEMORY table. I want to load the data from my MyIsam table (say <code>PIN_DETAILS</code>) into MEMORY table (say <code>PIN_DETAILS_MEMORY</code>).</p>
  
  <p>When I try to dump the data of <code>MyISAM</code> table into MEMORY table (using <code>INSERT INTO...SELECT</code>), only <em>8190</em> rows get copied into the memory table. I have nearly 2 lacs records into MyISAM table. I have also tried to change <strong>*max_heap_table_size*</strong> without any luck. Can you please suggest any solution?</p>
  
  <p>UPDATE:</p>
  
  <p>My SQL query to insert data is </p>
  
  <pre><code>INSERT INTO PIN_DETAILS_MEMORY (COL1,COL2,COL3,COL4) SELECT COL1,COL2,COL3,COL4 FROM PIN_DETAILS
  </code></pre>