title: Import of 8GB mysql dump takes a long time
body: <p>I've got an 8GB MYSQL database dump of InnoDB tables created with mysqldump. I import the data with:</p>
  
  <pre><code>mysql -uroot -p my_db &lt; dump.sql
  </code></pre>
  
  <p>An 5 GB dump of the DB was imported within an hour. The 8 GB dump takes 50 hour and counting. When I inspected the processlist with </p>
  
  <blockquote>
    <p>SHOW PROCESSLIST;</p>
  </blockquote>
  
  <p>Most of the time there was a single INSERT query visible with state "'freeing items"</p>
  
  <p>Is there a way, besides copying the raw files, to speed up the import process?</p>