I am trying to put together an automated solution to keep two MySQL databases (specific tables only) synchronised. Both databases run on Linux machines.
I would like to run the synchronization as a cron job on one of the Linux machines. Is this possible? I can't quite work out whether webyog is a Windows-only solution, or whether the synchonization part of it can run solely on Linux as a command-line utility.
If not, then are there any other solutions that you know about and that do a similar job?
For design and development SQLyog is great. For database synchronization it is also great (I'm running the enterprise trial version). But as an automated process, do I have to schedule it to run under Windows?
— Jason