title: How do I import a local MySQL db to RDS db instance?
body: <p>I've created a RDS instance called realcardiodb (the engine is mysql)
  and I've exported my database from my localhost. File is saved locally called localhostrealcardio.sql</p>
  
  <p>Most research says to use mysqldump to import data from a local system to a web server, but my system doesn't even recognize mysqldump.</p>
  
  <pre><code>C:\xampp\mysql&gt;mysqldump
  'mysqldump' is not recognized as an internal or external command, operable program or batch   file. 
  </code></pre>
  
  <p>How do I resolve this error should I use mysqldump? (I definitely have mysql install on my system)</p>
  
  <p>Is there a better utility I should use?</p>
  
  <p>Any help is appreciated, especially if you have experience importing mysql to aws rds.</p>
  
  <p>Thanks!
  DK</p>
  
  <p><strong>Update 7/31/2012</strong>
  So I got the error resolved. mysqldump is in the bin directory C:\xampp\mysql\bin>mysqldump
  AWS provides the folloinwg instructions for uploading a local database to RDS:</p>
  
  <pre><code>mysqldump acme | mysql --host=hostname --user=username --password acme
  </code></pre>
  
  <p>Can someone break this down for me?</p>
  
  <p>1) Is the first 'acme' (after mysqldump command) the name of my local database or the exported sql file I saved locally?</p>
  
  <p>2)Is the hostname the IP address, Public DNS, RDS Endpoint or neither?</p>
  
  <p>3)The username and password I assume is the RDS credentials and the second acme is the name of the database I created in RDS.</p>
  
  <p>Thanks!</p>