title: Importing 10 GB SQL file
body: <p>I have 10 GB SQL file with millions of rows in 72 tables. My storage engine is <strong><em>innodb</em></strong>.</p>
  
  <p>I have created the database with all required tables and issued the following command in MySQL prompt:</p>
  
  <pre><code>mysql&gt; source path/to/my/sqlfile.sql
  </code></pre>
  
  <p>It would run great until it got to about 10% of the way. 
  It would start fast and after a few minutes or later it slow down to three seconds per insert statement and it keeps slowing to 10 seconds per insert.</p>
  
  <p>It has been running for three days now and 30% of data has been restored.</p>
  
  <p>I can't figure why is it so slow ?</p>