This release ports a single critical bug fix from the newly released 8.55 release to the current 8.6 beta/development tree:  If user edited data in RESULT-tab GRID and changed from Edit Mode to Read Only mode without saving, the UPDATE statement would omit the proper WHERE-clause. As a consequence all rows would be updated. This bug was introduced in 8.4. All users using 8.4 or higher should upgrade due to this serious bug.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(2)

Changes (as compared to 8.54) include:

Bug Fixes:
* If user edited data in RESULT-tab GRID and changed from Edit Mode to Read Only mode without saving, the UPDATE statement would omit the proper WHERE-clause. As a consequence all rows would be updated. This bug was introduced in 8.4. All users using 8.4 or higher should upgrade due to this serious bug..
* Sorting and filtering on YEAR-type columns in RESULT tab did not work.  Now it works with YEAR(4), but with YEAR(2) it still does not with this release.
* A connection tab/window can now be closed even if there is only one connection (this fix is backported from 8.6 beta release).
* Fixed an issue with Schema Sync when source and target differed in both columns and Foreign Keys. Sometimes the ALTER script would only specify the FK-changes to target (also this fix is backported from 8.6 beta release).

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes (as compared to 8.54) include:

Features:
*User Management is completely redesigned and rewritten. Now privileges on all levels – as well adding/deleting/renaming users and changing passwords – are managed from the same interface – an expandable tree view. Also GRANT and REVOKE syntax is now used (before the MySQL privileges tables were manipulated directly).
* Added a ‘custom filter’ option in DATA and RESULT tab GRIDs. With this option, user can filter on any value from any cell.
* A connection tab/window can now be closed even if there is only one connection

Bug fixes:
*In text-mode, columns in DATA and RESULT tab would not align properly with non-ASCII characters. We were basically counting bytes – not characters. This is now fixed. But note that alignment issues may still happen in special cases with some non-western scripts in cases where the font itself prints more characters with the width of a single character.
* Fixed an issue with Schema Sync when source and target differed in both columns and Foreign Keys. Sometimes the ALTER script would only specify the FK-changes to target.
* Fixed some bugs when migrating default values from SQL server using Import External Data. Issues were occurring with specific default values and datatypes.
* Terminating a job from SJA wizards was not killing the PLINK process used for SSH-tunneled connection.
* The dialog for defining ENUM/SET properties only appeared after clicking the ‘length’ cell from CREATE/ALTER TABLE. Now it pops up as soon as user has selected the ENUM/SET type.
*The output in the MESSAGES tab is restructured to make the output more readable when multiple queries are executed.
* Other small GUI fixes.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(4)

Changes (as compared to 8.53) include:

Bug fixes:
* With many servers/connections registered in SQLyog the drop-down list in the connections dialog would flicker. The flickering was introduced in 8.5.
* Query Formatter was not handling queries of size greater than 2 KB. Now the size is increased to 8 KB. The 2 KB limitation was introduced in 8.18.
* Import of data from .xlsx files from Excel 2007+ was failing with double-precision datatypes.
* Update-check failed if SQLyog was running behind a HTTP-proxy.  The settings will now be detected.  However proxies requiring authentication are not handled with this release.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Important note: Please note that if you have installed a MONyog 4.0 (beta) release you cannot install this one unless first completely removing the 4.0 installation including the complete MONyog data folder.

Changes (as compared to 3.76) include:

Bug Fixes:
* Fixed an issue with SQLite where incorrect handling of journal files could lead to corruption of the MONyog embedded database .

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Important note: Please note that a 4.0 release cannot be downgraded to 3.x as the database schemas are incompatible and the installer will not handle downgrades – only upgrades. However you can install this 4.0 beta 2 on top of any previous release.

Changes (as compared to beta1) include:

Features:
* Added an option to compare server configurations. This feature enables the user to compare changes in configuration between two instances of MySQL. Through this feature the user will gain a greater insight on why one server is performing better than the other as far as server configuration is concerned.
* Also changes in server configurations are tracked and recorded by MONyog. This feature enables users to track changes to global configuration of a MySQL server over a period of time and compare changes between revisions.

Bug Fixes:
* Monitors/Advisors Customization: The Group Name of a Monitor/Advisor can now be changed only when a new, custom, counter is created; once set it cannot be changed. Changing Group Names of Monitors/Advisors shipped with MONyog is not allowed.
* Helper functions’ migration: User-defined helper functions were not being migrated in 4.0 Beta 1. If the user wrote his/her own function to use in his/her custom Monitors/Advisors, he or she would lose all changes upon upgrading. Now all helper functions are migrated transparently.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Bug fixes:

• SJA was always using port 22 to connect to SSH, but now any valid SSH port can be used to establish connection with MYSQL server using SSH.
• Fixed a PLINK crash which was introduced in SQLyog 8.5.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Bug fixes:

• Solved an issue with SSH connection when PuTTY is present. PLink was using the default settings of PuTTY to connect, resulting error in connection (Introduced in 8.5).
• Solved an issue with SSH connection where SQLyog was reporting Error No. 2003 even if the MySQL port was correct (Introduced in 8.5.1).
• If MySQL connection used “anonymous user”, SJA was throwing an error.
• For create/alter database, collation drop-down list did not populate values correctly if TAB key was used to select the charset.
• In Scheduled backup if the database name contains Non-ANSI characters, export was failing when ‘ALL database’ option was selected.
• Fixed the way keyboard shortcuts Ctrl+Tab and Ctrl+Shift+Tab behave.

Miscellaneous:

• Selecting a connection from the drop-down list of connection window is now faster.
• Keyboard shortcut Ctrl+W now closes the current connection tab. Keyboard shortcut for the Database Synchronization tool has been changed to Ctrl+Alt+W.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(2)

Changes (as compared to 8.5) include the bug fixes:
*The ‘Export Table Data As…’ option from the object browser menu was exporting just the column headers, this was introduced in 8.5 GA.
* In the Notification Services wizard, if a field contained data with quotes, SJA was inserting an extra slash along with the field value.
*The ‘timeout’ for establishing connection using SSH has been increased from 15 seconds to 30 seconds (15 seconds was too less to establish connection with slow SSH servers)

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(1)

Hi,

We are pleased to announce the release of SQLyog – MySQL GUI 8.5 GA. Below are some pointers:

• As the title suggests this release comes with tabbed interface for different connections. We need not have to emphasize the usability of a tabbed interface vs. a windowed one. All web browsers have already demonstrated it to us. Now in SQLyog, you can switch between different connections in a snap! We didn’t forget to add keyboard shortcuts to jump from one tab to other. Most – if not all – shortcuts for tabs of a standard web browser would work with SQLyog. Multi-coloring of connection tabs & object browser pane adds to the ease of use. Chances of one executing queries in one server than the other by mistake would be rare as the brain would easily grasp the connection by it’s color. Demoed below is a typical setup of multi-colored tabs in a Web Developer’s PC:

• If you remember we added client side sorting of Result set data in SQLyog 8.4. With this release you can even filter the data of Result set on client side unlike Table Data where a query is fired to server for every sort or filter action. One more addition to view relevant data quickly.
• Who likes to right-click & open a file when you can just drag-and-drop? We bet you don’t. You can drag-and-drop files (SQL or Schema Design XML/Query Builder XML) directly into SQLyog.
• Whoever uses SQLyog for data entry or manipulation would love this feature to duplicate data in a record. Many a time all one needs is to change only few fields & retain the rest of the data from the preceding row. This feature would come handy in such cases. Tables with auto_increment columns are handed automatically.

This release also contains many more enhancements & bug fixes. Refer the following release notes for details:

• SQLyog 8.5 RC3 Release Notes
• SQLyog 8.5 RC2 Release Notes
• SQLyog 8.5 RC Release Notes
• SQLyog 8.5 beta3 Release Notes
• SQLyog 8.5 beta2 Release Notes
• SQLyog 8.5 beta1 Release Notes

SQLyog customers can download the latest installer from Webyog’s Customer Portal.
To evaluate SQLyog, please download the 30-day trial.

We are very excited about this release, and hope that you will like it. We would love to hear from you.

Cheers,
Team SQLyog

Comments(18)