title: MySQL console slow on import of huge SQL files
body: <p>My import of SQL via the MySQL console is rather slow, and, as our SQL file is increasing every day, I would like to know if there are any alternatives on how to import an SQL file faster.</p>
  
  <p>Changing to Oracle or other systems is not an option, the configuration has to stay the same.</p>
  
  <p>Currently the SQL file is: 1.5 GB.
  I'm on <a href="http://en.wikipedia.org/wiki/WAMP" rel="noreferrer">WAMP</a> with Apache 2.2.14, PHP 5.2.11 and MySQL 5.1.41.</p>
  
  <p>Perhaps the issue is here, import is done by a simple:</p>
  
  <pre><code>mysql -u username -p dbname &lt; sqlfilename.sql
  </code></pre>
  
  <p>Any suggestions?</p>