The problem: I need to backup a few servers databases (sometimes a single table, other times all tables in the database) and also in once case replicate a database on a nightly basis.
So this is database to database copying. You may say, use mysql replication however I’m trying to achieve this without using mysql replication as I don’t always have access to configure this on remotely hosted servers.
To clarify, these are servers at different locations and not in the same location. I’m aware of many solutions when the tables exist in databases on the same server but options seem much more limited when this isn’t the scenario.
I need this to run on a schedule I can setup, say once a day in a totally automated fashion, copying and overwriting the target tables with the data from the source.
I’m aware through the research I’ve done of a windows commercial product that can do this (SQLyog) but I wanted to see if anyone knows of alternatives and maybe for Linux as well as Windows.