Tag Archives: Amazon

Backing up and Restoring your MySQL RDS Instance (and other Cloud DBs)

As more and more things move to the “cloud” as a Sys Admin you might find your self tasked with managing a Database that you don’t have shell access too. That has been the case for me with my last two jobs, Laughing Squid and now as Senior Sys Admin at Oxygen Cloud. With Oxygen we needed to backup some AWS RDS Instances and wanted to do it using a server on EC2 so we don’t have the bottle next of our local internet. This same method works with Rackspace Cloud Sites which I used at Laughing Squid. Its use a little known (could not find it easily with a google search) trick with mysqldump

mysqldump -P <port#> -h <server ip>-u mysql_user -p database_name table_name > backup.sql

To restore your DB in the cloud you use a more well-known mysql technique

mysql -u mysql_user -p -h <server ip> cloud_db_name < backup.sql

Amazon Route 53

Just moved one of my domains to Amazon Route 53 after zoneedit cant handle the current DDoS they are under and they are not updating information very well.  I know they are free so I guess you can expect crappy service but I also pay for another domain that I am going to move to Route 53 if this test goes well.  But the current setup for Amazon Route 53 is a PITA unless you plan on building a script to use the API or use a 3rd party tool like cli53