如何复制使用RDS数据库 [英] How to copy a database using RDS

问题描述

我对RDS与它2数据库的数据库实例。是否有使用RDS的命令行工具来复制一个数据库到其他的好办法？如果没有，是什么做的推荐方法？

I have a database instance on RDS with 2 databases on it. Is there a good way using the RDS command line tools to copy the one database to the other? If not, what is the recommended way of doing it?

在此先感谢。

推荐答案

我会使用 mysqldump的获得的表，然后的MySQL 来导入。

I'd use mysqldump to get the tables and then mysql to import them.

更新2014年7月8日：根据你打算在这里做什么，今天另一种解决方案是设置复制，然后促进奴隶成为主人。也就是说，例如，如果你想更新你的数据库的发布/版本： http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide /USER_ReadRepl.html

Update 2014/07/08: Depending on what you're planning to do here, another solution today is to setup replication and then to promote the slave to be the master. That is for example if you want to update your database's release/version: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

如果你想备份外，另外还有复制： <一href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html" rel="nofollow">http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html

If you're looking to backup externally, there's also replication: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html

RDS已经走过​​了很长的路要走。

RDS has come a long way.

这篇关于如何复制使用RDS数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！