Changes (as compared to 9.01) include:

Bug fixes:
* The option in ‘preferences’ to ‘Keep focus on SQL editor after query execution’ did not have any effect. This bug was introduced in 9.0.

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

Comments(0)

Please note that when upgrading from a previous version to this one, it is required that MONyog detects the replication topology of registered servers before the ‘registered servers’ page can display. This may take a few minutes with a large number of registered servers. Please be patient for as long. Note that this delay will only happen once.

Changes (as compared to beta 2) include:

Bug fixes:
* Emails sent by MONyog were missing the date in header.
* A slave will indent with its master in a hierarchy while displaying in the list of servers page. In the betas it did with freshly registered slaves only and not slaves migrated from previous program versions.
* User-defined ‘point-in-time’ custom Dashboard charts on system counters did not work as expected.
* Fixed small issues with the automatic replication topology detection introduced in beta 1 and 2.
* UI fixes, code optimizations etc.

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

Comments(1)

Changes (as compared to 9.0) include:

Bug fixes:
* Introduction of the option to TRUNCATE TABLE in the ‘Import External Data Tool’ introduced a bug. If user selected DROP+ (RE)CREATE TABLE only structure would be created but data would not be imported.

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

Comments(1)

This is the first GA release in a new major branch of the SQLyog MySQL GUI.

This release introduces an easy way to look up proper values for values inserted to columns that have a Foreign Key CONSTRAINT.  Foreign Key CONSTRAINTs can be difficult to handle for a human user because when updating a ‘child’ table valid values for columns that have such CONSTRAINTs  in the  ‘child’ table will often be ‘just a code’ ( an autoincrement integer or some very ‘compressed’ and ‘symbolic’ values (like item numbers, order numbers etc.).

This SQLyog release provides a direct way to look up in ‘parent’ what should be inserted in child. It works like this: In both GRID and FORM mode a ‘…’ symbol will display if the actual column has a Foreign key CONSTRAINT. If you enter some value in the cell and next click this button SQLyog will find all matches for what you have entered in the ‘parent’ table. It does so in two steps:

1) First it will try to find an exact match (using ” = ” operator) in the ‘parent’ column of the ‘parent’ table. So if you are able to memorize, the full matching row from ‘parent’ will display and you can verify with a single click.

2) If no match is found in first step it will try to find a ‘fuzzy’ match (using ” LIKE ” operator with wildcards attached to the string before and after) against all columns of the ‘parent’ table.

A new dialog with the result of this search is displayed. Once the search results display you can select any matching row found in ‘parent’ table and SQLyog will take care that a correct and valid value is inserted to the ‘child table’. If the first search returns too much ‘noise’ you may search again specifying customizable filters.

Note that the search string will not need to be a valid value for the ‘child’ column as it is not saved.  It is used for searching in the ‘parent’ table . Even the (rare) situation where a ‘child’ colum has more than one ‘parent’  is handled.

Other changes (as compared to 8.82 ) include:

Registration:
* Please note that this release requires a new registration code as compared to previous 8.x versions.  Before installing please ensure that you have the registration details available.  Existing customers may retrieve the details from our Customer Portal.

Features:
* In CSV-exports NULL-values can be written as a user-specified string. ‘\N’ is default for compliance with MySQL (SELECT INTO OUTFILE and LOAD DATA), but for use with other programs (such as spreadsheets) other options may be relevant.
* Added an option to automatically add ‘child’ tables to selected tables (before it was only possible to add ‘parent’ tables) in Schema Designer and Query Builder.
* Added a “Change Background Color” option in Edit menu
* A foreground color for text display contrasting a defined background color is now automatically provided by SQLyog in Object Browser and Connection tab.
* The visual effects of tabs have been improved with continued scrolling support. There is a + icon next to the last tab which provides options to add new tabs.
* In ‘Import External Data’ there now is an option to TRUNCATE target tables. Before only DROP+CREATE was possible.
* In ‘Import External Data’ added an option to discard/clear column DEFAULTs. Some ODBC-sources use default specification that will not work with MySQL and it was tedious to define this for every table when a large number of tables were imported.

Bug fixes:
* Data entered from the GUI to mange ENUM/SET types were not escaped properly what caused problems with the ” ‘ ” (single quote) and ” \ ” (backslash) character.
* Focus in Object Browser was lost when creating a Stored Procedure.
* There is now a button/link to open the log file in each dialog wherever it is referred.
* Fixed an issue where non-binary data were displayed as “(Binary/Image)”.
* Now TAB/SHIFT+TAB keys will rotate through buttons, check-boxes and tools in Result/Table Data tabs.
* Fixed a crash occurring when running Schema Sync and a Query Builder or Schema Designer TAB was active in the program main window.
* Fixed a truncation issue while importing binary data from PrimeBase server.
* When repeatedly stepping forward and backwards in SJA wizards most recent data entered by user could be lost and replaced with previous values.
* Deleting multiple rows af a table without a Primary Key in one operation could crash SQLyog. This bug was introduced in 8.8.
* Fixed a crash occurring when connecting on some Windows 7 systems with Service Pack 1 installed.
* While formatting multiple queries the SQL formatter now does not add a new line if a new line already exists between two queries. Formatting multiple times would insert new empty lines between queries for each cycle.
* A few more Query Formatter ‘refinements’.
* When closing a Query tab or a Query Builder Tab user was promted to save even if he/she had ‘blanked’ the content of the tab. Now it does not unless the tab was populated from a file. SQLyog will still prompt user to save in this case.
* A small GUI fix with the ENUM/SET dialog.
* After dropping a column from Object Browser context menu focus in Object browser would change randomly. Now focus will be retained on the parent COLUMNS folder.
* SQLyog could crash when attempting to delete rows from the table having a foreign key constraint. This bug was introduced in 8.82 due to improvements made in scrolling.
* SQLyog could crash while the table contents were being loaded in table data tab and the user tried altering the table at the same time.
* If server had timed out the connection SQLyog could fail to reconnect when opening a ‘stored program’ definition

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

Comments(1)

Changes (as compared to beta 2) include:

Features:
* We have removed the Data Search feature (introduced in beta 1) from this RC. It will be resumed after 9.0 GA release. We want to enhance it and it also needs more testing.

Bug fixes:
* After dropping a column from Object Browser context menu focus in Object browser would change randomly. Now focus will be retained on the parent COLUMNS folder.

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

Comments(0)

Changes (as compared to beta 1) include:

Features:
* Auto-registering of slaves is now extended to support multiple levels of replication.

Bug fixes:
* The ‘state’ information for ‘locked queries’ was not available in the SNMP traps.
* Sometimes exporting slow query log as CSV did not give the correct values. This bug was introduced in beta1. Current 4.2 GA version is not affected.
* MONyog could hang while dowloading slow or general logs from a server if the server wrote new entries to the log at download-time.
* Fixed small usability issues.

Miscellaneous:
* The ‘Event Overview’ introduced in beta 1 has been moved to the top-most menu level of the GUI.

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

Comments(0)

Changes (as compared to beta 1 ) include:

Features:
* Improved, ‘polished’ and fixed issues with the new features introduced in beta 1 (Foreign Key lookup and Data Search).
* A foreground color for text display contrasting a defined background color is now automatically provided by SQLyog in Object Browser and Connection tab.
* The visual effects of tabs have been improved with continued scrolling support. There is a + icon next to the last tab which provides options to add new tabs.
* In ‘Import External Data’ there now is an option to TRUNCATE target tables. Before only DROP+CREATE was possible.
* Added an option to automatically add ‘child’ tables to selected tables in Query builder. Before it was only possible to add ‘parent’ tables.

Bug fixes:
* When repeatedly stepping forward and backwards in SJA wizards most recent data entered by user could be lost  and replaced with previous values.
* Deleting multiple rows of a table without a Primary Key could crash SQLyog.  This bug was introduced in 8.8.
* Fixed a crash occurring when connecting on some Windows 7 systems with Service Pack 1 installed.
* While formatting multiple queries the SQL formatter does now not add a new line if an empty line already exists between two queries. Formatting multiple times would insert new empty lines between queries for each cycle.
* A few more Query Formatter ‘refinements’.
* When closing a Query tab or a Query Builder tab user was prompted to save even if he had ‘blanked’ the content of the tab. Now it does not unless the tab was populated from a file. SQLyog will still prompt user to save in this case.
* A small GUI fix with the ENUM/SET dialog.

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

Comments(0)