title: How to Import 800MB .sql file to XAMPP for windows /phpmyadmin
body: <p>I want to import over 800MB size sql file to <code>MySQL</code> database in localhost <code>XAMPP/phpmyadmin</code>. But phpmyadmin UI doesn't allow to import more than 2MB.</p>
  
  <p>What are the possible ways to do that such as any <code>SQL</code> query to import <code>.sql</code> file ?</p>
  
  <p>Thank you in advance</p>
  
  <p>I found that I can change the following values to php.ini file in xampp</p>
  
  <pre><code>post_max_size = 2M
  max_execution_time = 30
  max_input_time = 60
  upload_max_filesize = 2M
  </code></pre>
  
  <p>What is the bect time for execution and input in order to not have exceptions and upload my file successfully?</p>
  
  <p>Because it gives me something like this (this happens when I try to upload the zip file from sql file):</p>
  
  <pre><code>Fatal error: Out of memory (allocated 728760320) (tried to allocate 723280395 bytes) in C:\xampp2\phpMyAdmin\libraries\zip_extension.lib.php on line 55
  </code></pre>
  
  <p>When I try to upload the pure sql file it gives me this:</p>
  
  <pre><code>Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp2\phpMyAdmin\libraries\dbi\DBIMysqli.class.php on line 290
  </code></pre>
  
  <p>I have set in php.ini file the following:</p>
  
  <pre><code>post_max_size=1800M
  max_execution_time=10000000
  max_input_time=10000000
  upload_max_filesize=900M
  </code></pre>