AWS RDS MYSQL How do I reduce the DB size? Possible Duplicate:
  How do I reduce the database size on AWS RDS MySQL?  




I have a mysql DB on Amazon. It is bigger than I need and I don't want to pay so much.

How do I make it smaller? Their site says you have to do it some magic way (from backups or such), but I don't want to mistakenly wack it!
One idea (wholly un-researched, so there might be a better way, but this should work):


Create a new RDS instance that is smaller in size.
Dump the old one into the new one:

mysqldump -h &lt;old-RDS&gt; -u &lt;user&gt; -p&lt;password&gt; | mysql -h &lt;new-RDS&gt; -u &lt;user&gt; -p&lt;password&gt;

Whack the old one.


Of course, this assumes your total db size is smaller than 20GB, and that you're just looking to end up with a smaller instance. If you're trying to shrink the size of the database, in total, that's a different question.