Tuesday, April 30, 2013

Backup/ Restore AWS MySQL RDS

You can back up and restore your AWS MySQL RDS in simple few steps


  1. MySQL should be in the class path
  2. mysqldump -h boundydb.xxxxxxxxxxx.ap-southeast-2.rds.amazonaws.com -u root -p boundydb > dumpdb.sql
  3. mysql -u root -p boundydb < dumpdb.sql