Released: Aug 5, 2015

Updates in this release

Updates in 12.13

Bug fixes:

• Due to use of an old Plink version in older versions of SQLyog, SSH-tunnel could not be created to servers running OpenSSH 6.9x (as now available with Fedora 22 and possibly other 'bleeding-edge' Linux distros). We upgraded Plink to version 0.64 (latest) in this release.
• In rare cases, with an orphaned Plink process started by SQLyog running, the sqlyog.ini file could be locked and thus could not be edited in a text editor for instance.

Released: May 19, 2015

Updates in this release

Updates in 12.12

Features:

• XML files can now be imported from GUI controls in table menu/context menu provided that details of the XML follows one of the three supported XML-schemes supported by MySQL LOAD DATA XML syntax. This includes XML files generated with SQLyog and mysqldump.

Bug fixes:

• Server name in object browser was displaying wrong in some cases.
• JSON export added in version 12.11 could add an extra delimiter what could cause an error in the environment where the JSON was used...

Released: Apr 27, 2015

Updates in this release

Updates in 12.11

Features:

• Added option to export table data and result sets as JSON.

Bug fixes:

• On Windows systems using a recent wininet.dll, setting the HTTP timeout higher than 30 seconds had no effect and SQLyog would fire same query 3 times if HTTP tunneling was used and query executed on server for more than 30 seconds.
• Fixed a performance regression with "execute SQL script".

Miscellaneous:

• The new icons and other graphics introduced in 12.1 now have slightly darker and brighter colors...

Released: Mar 26, 2015

Updates in this release

Updates in 12.1

Rolling out a major design refresh to the powerful manager, admin and GUI tool for MySQL and MariaDB. The aim of this release is to deliver a modern look and improve the overall SQLyog experience.
With the redesigned SQLyog, you'll get a fresh GUI without the need to relearn anything. Every pixel of the app has been retouched to improve both form and functionality.

Released: Mar 2, 2015

Updates in this release

Updates in 12.09

Bug fixes:

• Fixed a crash on ALTER TRIGGER introduced in 12.08. This crash was due to unavailability of SHOW CREATE TRIGGER (in MySQL server before 5.1 or due to a MySQL Bug). The patch in 12.08 failed on such environments. We will now revert to old logic if SHOW CREATE TRIGGER is not available or returns an error or an empty string.
• Same problem as listed above could cause a crash in Schema Sync.
• Import External Data would map a MS SQL varchar(max) datatype to a MySQL 'varchar'...

Released: Feb 9, 2015

Updates in this release

Updates in 12.08

Features:

• Added option to prefix files with timestamp as well as 'file per table' option in "export as SQL dump" dialog. This is now available in Professional and higher versions of SQLyog.

Bug fixes:

• Launching "Visual Data Compare" from data synchronization wizard could fail. From 'powertools' menu there was no such issue. This bug was introduced in SQLyog 12.04.
• Escaped strings in a TRIGGER definition could have the escapes removed when copying and when using Schema Sync. This...

Released: Jan 29, 2015

Updates in this release

Updates in 12.06

Bug fixes:

• The computed colums functionality, introduced in 12.05, executed a SHOW CREATE TABLE with database and table indentifiers not `backquoted` in the background. As a result ALTER TABLE was not available for tables with some characters (such as SPACE) in database and table identifiers.

Released: Jan 28, 2015

Updates in this release

Updates in 12.05

Features:

• SQLyog now supports computed (virtual/persistent) columns for MariaDB 5.2+ servers.

Bug fixes:

• Result tab could display wrong execution and total time in status bar.
• When using SSH tunnel and the SSH daemon used was on another host than the MySQL server connected to, SQLyog would display the connection as a connection from localhost and not from the SSHD host.

Miscelaneous:

• Changed the rendering mechanism used on high-resolution monitors, where Windows as default will...

Released: Dec 23, 2014

Updates in this release

Updates in 12.04

Features:

• Added support for the 'clear-text plugin' (used by Oracle/MySQL LDAP authentication) and the 'dialog plugin' (used for MariaDB PAM authentication). Unlike the LDAP support available in early 11.x versions there is no user setting for either. SQLyog will transparently for user detect how to communicate with the server during authentication.
• It is now possible to save current setting of Visual Data Compare in a job file. This job file will be compatible with Data Sync...

Released: Nov 25, 2014

Updates in this release

Updates in 12.03

Features:

• Data Sync will now run in a single transaction using REPEATABLE READ transaction isolation mode on source.

Bug fixes:

• The fix in 12.02 related to (DATE)TIME datatypes using fractional seconds was not complete. In some cases Schema Sync could still add quotes where it should not.
• If the target for Schema sync differed from the currently selected database in the main program dialog, inconsistent database name could display in some cases. A consequence was that SQLyog...