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
Keith Bucknall 11:42 am on April 4, 2012 Permalink
Hi there, great post, can I ask if you could package the Oxygen storage connector into a distro to sit on top of the Blazepod – in essence creating a OC appliance?
What are the Oxygen tunnel gateways are these the same as the storage connectors?