title: export large database mysql phpmyadmin
body: <p>I am using phpmyadmin on my windows os. I have a database with one table which has 100M records with the size of 20GB. I want to export this table and have the table.sql file. Whenever I try to do this, the size of the exported file is 0 bytes. When I check the apache error log, the following would show up:</p>
  
  <pre><code>Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1066139648 bytes)
  </code></pre>
  
  <p>Any idea how to solve this problem?!</p>
  
  <p>Thanks :)</p>