[Ritesh]

Have you tried “Tools->Power Tools->Database Synchronization Wizard…”?

[Ritesh]

Are you specifying the same local port for both the servers ( for SSH tunneling )?

[Ritesh]

Oops. My mistake. I actually meant 4.1.7 to 4.0.17.

The SQL returned from 4.1.7 is not backward compatible. Therefore, they dont work with 4.0.17.

[Ritesh]

SQLyog uses the query returned from “CREATE TABLE…” SQL to create tables between two hosts. It looks like the SQL returned from 4.0.17 is not compatible with 4.1.7.

I have forwarded the issue to my development team.

[Ritesh]

Which version of MySQL?

[Ritesh]

We will fix this issue in one of the future releases of SQLyog.

[Ritesh]

Did you download SJA or SQLyog Max BETA 1?

[Ritesh]

Which version of MySQL are you trying to connect?

[Ritesh]

The error usually occurs when MySQL is not running or you try to connect to the wrong port.

Quote:

I can access this server from the Windows side just fine

Do you mean you can access the MySQL server? If you can then provide the exact same details in SQLyog also.

[Ritesh]

For “Lost connection to MySQL server during query”, check out http://dev.mysql.com/doc/mysql/en/Gone_away.html.

“Unknown MySQL Server Host..” error simply means that you are providing wrong host name while connecting to your MySQL server.

[Ritesh]

That is a wonderful news. I hope things are working as expected 🙂

[Ritesh]

Untar it using:

tar -xzvf sja40.tar.gz

Try executing it using the command:

root@] ./sja

[Ritesh]

This feature is already in the TO-DO list of SQLyog 😀

[Ritesh]

Please cut-n-paste the “CREATE TABLE…” statement for the table.

Sample data in CSV will be helpful.

[Ritesh]

Sounds cool 🙄

[Author]

Posts