1

Can someone point me to the correct direction or terminology? I've been searching about it but I can't find any relevant info. It may be the keywords or terms I'm using.

I have a one RDS instance with two MySQL databases. I'd like to copy data from some tables in Database A to Database B, a couple of times a day.

Is this possible? If it is, can you point me to some documentation?

Kara
  • 6,115
  • 16
  • 50
  • 57
Neil
  • 63
  • 5
  • Create a scheduled task/cron job to do this? – Ashley Medway Nov 17 '15 at 10:09
  • You can try [SQLyog](https://www.webyog.com/product/sqlyog) for accessing the databases in RDS. Give the MySQL host name,port,username and password to connect. Databases can also be [synced](http://sqlyogkb.webyog.com/article/292-starting-database-synchronization) with option for scheduling the sync. – Mathew Nov 17 '15 at 11:23

1 Answers1

2

You can use AWS Lambda Scheduled Events to access your RDS instance and copy the tables from your Database A to Database B.

Community
  • 1
  • 1
Lucas Azevedo
  • 1,097
  • 15
  • 36