Forum Replies Created
-
AuthorPosts
-
October 4, 2016 at 7:58 am in reply to: Slow To Load Data When "execute And Edit" Query Selected #35785Sibin A SModerator
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,SibinSibin A SModeratorHi 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 SModeratorHello,
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.htmlPlease check for “skip_networking” and “bind_address” settings in MySQL configuration of the server that does not connect.Regards,
Sibin
Sibin A SModeratorHi,
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 SModeratorHello 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
September 7, 2016 at 2:10 pm in reply to: Is Sja Able To Update When New Fields Has Been Created On The Source T #35773Sibin A SModeratorHi,
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
September 6, 2016 at 1:44 pm in reply to: How Does Sja Know Which Records Has Been Updated Since Last Run? #35769Sibin A SModeratorHi,
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 SModeratorHello 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 SModeratorCan 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.htmlRegards,SibinSibin A SModeratorHello,
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.htmlYou may use the Winebottler package >> “http://winebottler.kronenberg.org/“ to set up the Wine environment.Regards,SibinAugust 29, 2016 at 2:48 pm in reply to: How Does Sja Know Which Records Has Been Updated Since Last Run? #35767Sibin A SModeratorHi,
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-tablesRegards,SibinSibin A SModeratorHi,
Can you please try connecting/testing the connection to the target server and verify if the server is running?
Regards,
Sibin
Sibin A SModeratorHi,
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.htmlPlease 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,SibinSibin A SModeratorHello 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
August 23, 2016 at 1:38 pm in reply to: Feature Request: Auto Copy Alter Table Sql To Clipboard #35757Sibin A SModeratorHello 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,
Instead, you may also use the ‘Schema Synchronization Tool’ to sync the changes in the table structure.
Regards,
Sibin
-
AuthorPosts