title: How to rename an Amazon RDS hosted MySQL database instance
body: <p>I tried using the rename database command, but it fails with the following error. I don't see an option to stop the RDS instance via the Amazon RDS console either. </p>
  
  <pre><code>mysql&gt; rename database foo to foo_orig;
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database foo to foo_orig' at line 1
  </code></pre>