I have a server online and I have installed MySQL and database A server on it.
I also have mysql installed on my local computer and have a copy of database A on it.
I want to compare the contents of the two databases, and possibly sync them using federated tables.
But after trying out federated table, it seems that I can’t even connect to the server.
The federated table that's supposed to be connected to (an online, not-empty) table from the server is empty.
Am I doing this right? Is this even possible?
If not, can you please suggest any tools/applications that can do this.