title: How to speed up import of .sql dump file in to AWS RDS instance?
body: <p>I'm trying to import a 55 meg .sql file in to an AWS RDS instance.  The dump file was generated with this command:</p>
  
  <pre><code>mysqldump -u root -ppassword dbname &gt; dbname.sql
  </code></pre>
  
  <p>I'm running the import with this command:</p>
  
  <pre><code>mysql -u root -ppassword --host=x.rds.amazonaws.com dbname &lt; dbname.sql
  </code></pre>
  
  <p>The import was running for about 20 minutes, so I decided to abort thinking something was hanging.  It aborted on a line which is 20% of the through, so it seems the import was working, but set to take about an hour and 40 minutes to import 55 megs of SQL.</p>
  
  <p>Is this normal?  If not, how can I do it right?</p>