I’ve been using Virtualmin for quite some time (and love it) to host some client web sites and their respective MySQL databases on Amazon EC2, and for a whole lot of reasons now plan to turn off the MySQL database server (on localhost) and instead use RDS.
I’ve discovered that individual customer DB snapshots are not available with RDS, and I can’t seem to configure Virtualmin to back up databases from a remote DB server (eg not localhost). I’d rather not write scripts and create CRON jobs for each customer to manage their backups, but I will if I have to.
Has anyone come up with an easy way to do this, ideally using the capability within Virtualmin (eg pointing it to a different MySQL server location)?
If not, where are the Virtualmin config files located so I can jump in and try and hard-code the new DB location (Amazon RDS)?