[Ritesh]

Are you using the Windows or Linux build of SJA? Version information of SJA would be helpful.

[Ritesh]

By output do you mean messages and errors returned after execution of query(s) or result(s) returned from a query(s)?

[Ritesh]

Information on “max_allowed_packet” can be found at http://dev.mysql.com/doc/mysql/en/Packet_t…_too_large.html

If you have lot of data in a table, uncheck the option – Create bulk insert statements

[Ritesh]

You would be able to resize the BLOB window in SQLyog Max.

[Ritesh]

This feature is already in the To-DO list of SQLyog.

[Ritesh]

As of SQLyog 3.71, FK in structure sync is not supported.

[Ritesh]

Can you send me backup of the databases and the corresponding XML file so that my developers can work on it?

It is very difficult to give a definite answer without looking into the data and the XML schema.

[Ritesh]

Mail me the XML file at [email protected]. Sample data and steps to reproduce the error would be great.

[Ritesh]

SJA will always try to bring the target database in sync with the source database. If two rows have the same PK values then the target db will be updated with data from source.

You are not doing anything wrong. It is the way that SJA behaves.

[Ritesh]

Can you give me the CREATE TABLE statement of the tables in both the databases?

[Ritesh]

Select Tools -> Preferences and un-check the option: Truncate Column Headers To Max Data Size

[Ritesh]

Are you sure that the MySQL server is up and running? Make sure that the MySQL server allows connecting from a remote host.

[Ritesh]

Probably a search in Amazon on database books will be helpful.

[Ritesh]

The best place to start learning MySQL would be the docs available at http://dev.mysql.com/doc/

SQLyog is a front-end tool that makes working with MySQL very easy. SQLyog logs all the queries that it executes to get various informations. You can read these queries to learn SQL and MySQL.

HTH

[Ritesh]

No. You can ask MySQL to listen on a different port.

The best person to tell you the connection details would be your MySQL Administrator.

[Author]

Posts