SQLyog Releases

June 14, 2017

Updates in v12.4.3

Fixes

  • Upgrades the MariaDB Connector/C to version 2.3.3 (current) which resolves incorrect timeouts on some environments.
May 17, 2017

Updates in v12.4.2

Features

  • Search function in Object Browser now supports regular expressions.
  • Important Notice: The tunneler file for HTTP-tunnel has been updated with this release and must be replaced on the server. Earlier HTTP-tunnel required PCRE-support in the server-side PHP-environment. Now it does not.

 

Fixes

  • Fixed a rare connection failure using SSH-tunnel to specific BSD systems.
  • Removed unnecessary virtual column check for older servers with no support for this.
  • Fixed a crash when a menu-item, that is...
March 01, 2017

Updates in v12.4.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 SQLyog doesn’t allow acquiring explicit LOCKS in read-only mode).

Fixes

  • On enabling HTTP, SSL or SSH checkbox in the connection manager, the checkbox wasn’t redrawn automatically. The checkbox were re-drawn only on hovering over them or switching to another tab in the...
January 25, 2017

Updates in v12.4.0

Features

  • Added an option for defining a connection as ‘read-only’.  There is a checkbox in the connection settings and when checked the title bar will inform user about the ‘read-only’ state. In ‘read-only’ state statements that write cannot be executed.
  • Added support for the MariaDB auth_gssapi (Kerberos) plugin. This plugin is available with the latest 3.0 (alpha) Connector/C from MariaDB. But there seems to  be a huge popular demand for this already, and Webyog has backported...
December 26, 2016

Updates in v12.3.3

Fixes

  • Fixed an issue where Import External Data -jobs failed to authenticate SMTP.
  • The sja.log would record syntax errors on recent servers if  Scheduled Backup was running with ‘Flush Master’ option. The generated backup file was OK. ‘Flush Master’ was deprecated in MySQL 5.6 and replaced with ‘Reset Master’. SQLyog now uses ‘Reset Master’ with such servers.
  • In email settings of Import External Data wizard it was possible to leave the subject empty.
  • When re-ordering columns...
November 18, 2016

Updates in v12.3.2

Fixes

  • If an INIT_CONNECT setting in server configuration specified SET AUTOCOMMIT = 0 and global AUTOCOMMIT was 1 (or non-existent as in MySQL 4.1 and 5.0), the ‘transactions’ menu in SQLyog would incorrectly display AUTOCOMMIT as 1 after connection.
  • Same code change as above also fixes a crash that could occur with 4.1 servers.
  • Transactions support would fail to initialize with servers running global ANSI mode. SQLyog will not work in ANSI mode but connection and...
November 16, 2016

Updates in v12.3.1

Fixes

  • 12.3.0 introduced a slowness when displaying the saved connections list with a large no. (100+) of saved connections. This is fixed now.
  • Fixed a rare crash occurring sometimes when typing in the editor inside an invalid query longer than 128 characters. Auto-complete was at fault.
October 26, 2016

Updates in v12.3.0

Features

  • GUI transactions support. This new feature is available in Enterprise and Ultimate editions. Also please see note below.
  • Added a tooltip on column headers in Data tab informing about column name, column type and length. In Result tab the tooltip will display column name only, as the result returned by MySQL does not have information of storage type details.
  • Added GUI support for index-level comments in CREATE/ALTER TABLE.

Fixes

  • Fixed an issue where GUI could ‘hang’...
September 12, 2016

Updates in v12.2.6

Fixes

  • SQLyog was not able to connect to RDS instances using SSL encryption. Attempting to do so returned the error “Failed to connect to MySQL: SSL connection error: certificate verify failed”.
  • After having a connection open for very long time, SQLyog could crash when closing this connection.
  • Corrupted connection information in the ‘session restore’-database could cause a crash. There was one reproducible report of this, but please note that there is no indication that SQLyog...
August 19, 2016

Updates in v12.2.5

Features:

  • Added basic support for the JSON datatype as of MySQL 5.7.8+ and MySQL Cluster 7.5.2+. The datatype is now available in the CREATE/ALTER TABLE dialog and JSON data will open in the BLOB-viewer. The BLOB-viewer validates the content is valid JSON. Also JSON-related keywords and functions are recognized in syntax highlighting and autocomplete.
  • SQLyog GUI now supports Foreign Key constraints between NDB tables for MySQL Cluster 7.3+.
  • It is now possible to filter the...