[Sibin A S]

Hi,

 

Can you please tell us in detail as it is not reproducible at our end,

 

1) Please tell your SQLyog version which can be found from the menu >> ‘Help -> About’. Also tell if your using 32-bit or 64-bit version.

 

2) Is this happening with a specific server or more/all servers? What about a local server installed with default parameters?

 

3) How do you connect? direct, HTTP or SSH?

 

4) Please tell the ‘wait_timeout’ and ‘interactive_timeout’ server settings (from SQLyog: tools .. show ..variables)

 

5) Does the table contain large data for which you perform Execute and Edit?

 

Regards,

Sibin

[Sibin A S]

Hi Chris,

 

Can you please tell if you have installed Office 2016 32-bit or 64-bit? Also tell us your SQLyog version and also tell us if it is 32-bit or 64-bit.

 

Regards,

Sibin

[Sibin A S]

Hello,

 

This seems to be a server issue as SQLyog is not able to connect to the respective server. Any client connecting from same host with same connection details would face the same problem. 

 

You may refer our FAQ that lists the reasons for this error, here >> http://faq.webyog.com/content/23/15/en/error-no-2003-can_t-connect.html

 

Please check for “skip_networking” and “bind_address” settings in MySQL configuration of the server that does not connect. 

 

Regards,

Sibin

[Sibin A S]

Hi,

 

We had removed this option from SQLyog v8.7 as there were issues with that implementation. The latest version does not include that option and is a completely rewritten to include all types of SQL statements.

 

You may also refer our blog for the same under the version 8.7, here >> http://sqlyogkb.webyog.com/article/348-version-history-2010

 

Regards,

Sibin

[Sibin A S]

Hello Mitch,

 

We are checking this issue. Due to the security reasons we cannot provide you the previous version link in the Forums. You could create a ticket by writing a mail at “[email protected]” and we could provide you the link in the ticket.

 

Regards,

Sibin

[Sibin A S]

Hi,

 

It is not possible to sync the schema of tables in two databases using SJA. But, you can sync the schema from the SQLyog GUI Interface.

 

You may refer our FAQ, here >> http://faq.webyog.com/showcat.html and the documentation, here >> http://sqlyogkb.webyog.com/

 

Regards,

Sibin

[Sibin A S]

Hi,

 

You may refer our doc for more information, here >> http://sqlyogkb.webyog.com/article/294-selecting-tables and http://sqlyogkb.webyog.com/category/321-sqlyog-job-agent-from-command-line

 

Regards,

Sibin

[Sibin A S]

Hello Matt,

 

Thanks for your valuable feedback. We have added your request into our issue tracker, here >> https://github.com/webyog/sqlyog-community/issues/2068

 

Regards,

Sibin

[Sibin A S]

Can you please check the currently open connections. You may execute the below statement to find the currently opened connections,

 

“SHOW STATUS WHERE `variable_name` = ‘Threads_connected’;” and you may also execute “SHOW PROCESSLIST” to verify the number of currently opened connections.

 

Please try increasing the max_connections value and then try, as this is the reason that you get the error. You may also refer the MySQL Official documentation regarding the same, here >> http://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html

 

Regards,

Sibin

[Sibin A S]

Hello,

 

Although SQLyog cannot be used on MAC OS directly, you can run SQLyog by running it on Wine. The details for the same can be found in our FAQ  >> http://faq.webyog.com/content/31/181/en/can-i-use-sqlyog-on-a-mac.html

 

You may use the Winebottler package >> “http://winebottler.kronenberg.org/“ to set up the Wine environment. 

 

Regards,

Sibin

[Sibin A S]

Hi,

 

SJA uses an efficient algorithm to generate checksums to find out the changes. Therefore only those rows that have been inserted, updated or deleted since the last sync are transferred between the hosts.

 

You may refer our doc regarding the checksum calculation for comparing the data between the databases, here >> http://sqlyogkb.webyog.com/article/294-selecting-tables

 

Regards,

Sibin

[Sibin A S]

Hi,

 

Can you please try connecting/testing the connection to the target server and verify if the server is running? 

 

Regards,

Sibin

[Sibin A S]

Hi,

 

This error is returned by the MySQL server since you are running out of connections. The reason would be that you are not closing the connections that you have open.

 

You have to change ‘max_connections’ to increase total permitted connections.

 

You may also refer the MySQL official documentation, here >> https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html

 

 

Please note, once the respective value is passed to the ‘max_connections’ variable, ensure that the server is restarted for the changes to come into effect.

 

Regards,

Sibin

[Sibin A S]

Hello Chris,

 

We will try reproducing this with similar number of rows. Also you can dump the oldest records if they aren’t required for you as it also decreases the load on the server as well.

 

Regards,

Sibin

[Sibin A S]

Hello Mitch,

 

All the changes that you make to the table from ‘Alter Table’ option can be viewed in the query format even before committing/saving the changes in the ‘SQL Preview’ tab. You may either save or revert the changes made to the table also. You may refer the below image,

 

SQL Preview.png

 

Instead, you may also use the ‘Schema Synchronization Tool’ to sync the changes in the table structure.

 

Regards,

Sibin

[Author]

Posts