SQLyog Ultimate 12.5.1

Features:
--Added an option to HEX-dump binary data in Export as SQL and in Scheduled Backup.
--In read-only mode FLUSH-statements can now be executed from the GUI as well as editor, except for ‘FLUSH TABLE WITH READ LOCK’ (as we don’t allow acquiring explicit LOCKS in read-only mode).

Bug Fixes:
--On enabling HTTP, SSL or SSH checkbox in the connection manager, the checkbox wasn’t re-drawn automatically. The checkbox were re-drawn only on hovering over them or switching to another tab in the connection window
--In Table Diagnostics, clicking on Analyse executed same query irrespective of ‘Local’ being checked or not.
--Changed the row count in Data Synchronisation Wizard to use a 64-bit integer. Before this the rowcount displayed would stop incrementing at a 10-digit number.
--Import from Excel did not handle cells with multiline text properly. A linebreak became a SPACE.
--For a non read-only connection, on right-clicking on a table, the Import External Data option was greyed out even though it could be accessed from the Powertools and shortcut key.
--The ‘date picker’ did not handle dates with a ZERO-day/month/year (as allowed in specific sql_modes). In such cases current date would be selected and inadvertedly clicking “OK” in the dialog would overwrite. Now nothing is selected and the OK button is ‘greyed out’ in such cases.
--Fixed a rare crash occurring when editing the password for a connection.
--Regression fix: In SQL backups an extra \r was added for every \r\n in stored routines.
--Schema Sync sometimes failed to sync indentations to target exactly like on source.

Bug Fixes:
Fixed a regression bug introduced in 12.2.3, that could have the result that various data dialogs displayed truncated or empty. Affected were “table diagnostics” and in some cases also Info, Data and Result tabs in text mode.

Features:
'session restore' now saves and restores content of open Query tabs.
As a consequence user is not prompted to save open Query tabs when the program is closed and 'session restore' is enabled. User is still prompted when closing an individual tab.
With 'session restore' enabled, session is now also saved automatically in the background every 10 seconds.
A Query tab can be renamed (from the context menu of the tab itself). 'session restore' will open the tab with the user-defined name.
Added the HTTP content-type 'application/xml' as an option for HTTP tunnel.
Import external data will now create tables with the database collation of the database imported to, provided that database charset is utf8. Note that we cannot do this if database charset is not uft8 as imported tables are always created as utf8 and comparable collations do not always exist for unicode and non-unicode charsets in MySQL.
Bug fixes:
Fixed a crash when executing a single bracket ( “(” ) as a statement.
Import External Data could fail when creating indexes on imported TEXT columns as the tool did not specify the mandatory index prefix length.
Miscellaneous:
The HTTP-tunneler has been updated with this release and users making use of HTTP tunnel must update the tunneler on their MySQL host. The previous tunneler – released with SQLyog 8.8 more than 3 years ago – used the function 'set_magic_quotes_runtime()' that has been deprecated for some time in recent PHP versions. Till now we have suppressed any errors resulting from this, but this is a permanent solution.

Version 11.41 introduced a dependency on the shared library ‘msvcr100.dll’ (installed with the ‘VC++ 2010 SP1 redistributable’ from Microsoft). Users that do not upgrade regularly from Windows Update for any reason (including company policies) could experience that the program failed to launch with a message about the missing .dll. This dependency has now been removed.

Upgraded libraries that theoretically could be vulnerable to the ‘Heartbleed’ OpenSSL bug. All users are urged to upgrade as soon as possible.

Features:
Added a notifications area appearing in the lower part of Object Browser area. This will be used to communicate important information to users (example: critical bugs affecting version currently used). When no notifications are available or when there is no Internet connection to the notifications service, the area will not display.
In Copy database, Export as SQL-Dump, Scheduled Backup and Schema Sync there is now an option to ignore/omit DEFINER-clause for database objects where it applies. Note that the target server will then create DEFINER as current SQLyog user when creating the object.
Added fractional seconds support for relevant data types if server supports (MySQL does from 5.6.4 and MariaDB does from 5.3) in CREATE/ALTER TABLE as well as in ‘Import External Data’.
Bug fixes:
Since version 11.0 SQLyog failed to read theme files other than the default ‘twilight’ theme.
Copying into clipboard from MESSAGES tab could result in garbage characters.
SSH usernames and passwords with a doublequote character were not escaped properly.

Bug fixes:
Schema Sync requires SELECT privilege to the `mysql` database for syncing non-table objects. If user did not have this privilege, SQLyog would display a generic message that the sync failed, but with no further information. We now ask user to check for privileges.
A slugginess could occur in the editor when typing a function name followed by a bracket. It could happen for instance if specific versions of the Notepad++ text editor was installed on the system before SQLyog was installed.
Miscellaneous:
The color used to indicate the selected row in DATA and RESULT grids is now clearer/brighter than before and thus more easily distinguishable from the darker rows of the grid.

Bug Fixes:
11.25 introduced a dependency on the VC++ redistributable for some Windows platform(s). If the redistributable was not installed SQLyog would not start. Affected was Windows 2008 Server r2 (at least).
Another dependency was introduced in 11.26 affecting Wine. Also here SQLyog could fail to start.
Fixed a rare case where connection to a SSH daemon failed while copying a database.
Fixed a crash in SJA when "To email" recipient was not specified in the job file.
With SSL connection the 'helper connection' opened in order to stop a running query would not use SSL. As a consequence the server could refuse this 'helper connection'.
When SQLyog was closed immediately after a 'copy database' operation and reopened by 'connections restore' only the database copied in previous session would display in Object Browser for the connection. Only SSH-connections were affected.
Miscellaneous:
SQLyog now uses "ALTER VIEW" statement instead of DROP and CREATE VIEW statements for ALTER VIEW operation.