title: Slow Large Innodb DB Import into Amazon RDS using mysqldump
body: <p>OK
  I am experimenting with Amazon RDS and am having heaps of trouble loading an InnoDB database using mysqldump in a timely manner.</p>
  
  <p>I am trying to get my local DB to the cloud.</p>
  
  <p>Using </p>
  
  <pre><code>mysqldump --single-transaction --opt -u root &gt; file.sql
  </code></pre>
  
  <p>I can get a dump (~1.5GB) in around 3 minutes to my local file.
  The database is about 4G but mysqldump produces an sql file about 1.5G</p>
  
  <p>When I use </p>
  
  <pre><code>mysqldump -h localhost -u XXXX -pXXXX DBNAME --compress --single-transaction --quick  --opt --order-by-primary| mysql --host=AMAZONHOSTNAME --user=username --password DBNAME
  </code></pre>
  
  <p>it takes forever - I estimate based on the rate its going it will take 5 hours.</p>
  
  <p>In terms of my bandwidth speed, on www.speedtest.net I get an upload speed of 0.67Mbps.</p>
  
  <p>I cannot understand why its taking so long.
  I am :
  a) compressing the stream
  b) have all the options that the forums seems to require as well as the Amazon docs
  c) have a LARGE instance on Amazon RDS.</p>
  
  <p>Can anyone help me here? Is there any way to improve the speed?</p>