I have created an RDS database and have used mysqldump to send all my local data to that remote database using the following commands:
$ mysqldump -u root fishDB > localDB.sql $ mysql -h fishinstance.xxxxxxxxx.us-east-1.rds.amazonaws.com -u mola -p fishDB < localDB.sql
Since AWS usage is costly and the database is about 1Gb (but only 5mb is new) and growing, I would like to setup a daily update and insert revised or new data instead of doing a data dump every time. I've read about possible solutions from Accessing to a remote mysql and Using Trigger to update table. Although both solution discussions are very compelling, after checking my local database, I discover that I do not have FEDERATED. I do have MyISAM.
I've also looked at Amazon RDS documentations and found it to be very limiting and can't figure out how to setup this procedure. Could you help me with setting up this update? I really appreciate your help.