The problem is that some MySql versions contain incompatible changes. SQLyog uses the 4.0.x client library (there is a separate version for 4.1.1 and up) and one of your server is 3.x. SJA may work under these circumstances as well, but nothing can be guaranteed.
About the error message: please check the key constraints, you might have different constraints on the two servers.