title: Is there a fast way to export MySQL data from AWS RDS and import it into Google CloudSQL?
body: <p>I have a 885 GB MySQL 5.6 database running in Amazon RDS.  I'd like to move it into Google's CloudSQL service.  To do so I'm taking the following steps:</p>
  
  <p>Following Amazon's instructions for moving a database out of RDS (since Google seems to require GTID for replication and RDS does not supported GTID for MySQL 5.6).</p>
  
  <ol>
  <li>Created a RDS read-replica.</li>
  <li>Once the read-replica was up to date with the master I stopped replication, recorded the binlog location, and dumped the database to a file.</li>
  <li>Brought up an EC2 instance running Ubuntu and MySQL 5.6 and I'm importing the dump file into the EC2 database.</li>
  </ol>
  
  <p>The problem I'm having is the import of the dump file into the EC2 database is taking much longer than I had hoped.  After about 3 and half days the EC2 instance is only about 60% done with the database load.</p>
  
  <p>The mysqldump command I ran was based off Amazon's recommendation...</p>
  
  <pre class="lang-sh prettyprint-override"><code>mysqldump -h RdsInstanceEndpoint \
      -u user \
      -p password \
      --port=3306 \
      --single-transaction \
      --routines \
      --triggers \
      --databases  database database2 \
      --compress  \
      --compact &gt; dumpfile.sql.gz
  </code></pre>
  
  <p>I decompressed the dumpfile and to import the data I am simply running...</p>
  
  <pre class="lang-sh prettyprint-override"><code>mysql -u user -p password &lt; dumpfile.sql
  </code></pre>
  
  <p>Is there anything I can do to make this process run faster?  Are there any command line options I should be using that I am not?</p>