To migrate from an Amazon RDS instance to an instance that is launched and created by using one of RightScale's database manager ServerTemplates. (e.g. Database Manager for MySQL 5.5 or Database Manager for MySQL 5.1)
If you are currently using an Amazon RDS instance for a database, but now want to use a ServerTemplate to launch and manage your database so that you have more control and visibility of your database, you can follow the steps below to migrate a running RDS instance to an instance that is launched and configured using a ServerTemplate instead.
Note: The steps only apply to an RDS instance running MySQL 5.1 or 5.5. Support for Oracle databases will be provided at a later time when Oracle ServerTemplates become available.
# sudo -i # mysqldump -h <rds_host> -u <rds_user> -p<rds_password> <database_name> | mysql -u root
# mysql mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec)
If you prefer to create a mysqldump file and save it to a directory so that you can upload it to an ROS container (e.g. S3 bucket), run the following command to create a mysqldump file from the running RDS instance and save it to the /tmp directory of the "master" database server.
Note: Remove '> /tmp/mydumpfile.sql' from the string to view the dump file in stdout format.
# sudo -i # mysqldump -h <rds_host> -u <rds_user> -p<rds_pass> <database_name> > /tmp/<mydumpfile>.sql
mydumpfile: The filename of the mysql dump file that will be created.
© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.