Moving MySQL Data from 1 RDS server to another
How do I go about moving certain data (returned by a simple query) from one database in AWS' RDS to another?
An interruption of up to 20 mins is acceptable, although not preferred.
My current plan is to use Sequel Pro to perform an Export, and then Import it into the target database, but I'm wondering if there's a better way to do it.
BTW: Database is mostly InnoDB and some MyISAM tables.
Your question is far from clear but if I interpret it correctly the simplest method is to use a select into
query, which inserts the results of a query into a table, which can then by copied to the target system using dump and load, or replicated as per coredump's suggestion.