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...

Released: Oct 23, 2014

Updates in this release

Updates in 12.02

Features:

• Exports to CSV and Excel XML can now optionally include BOMs (Byte Order Marks) or not. Before this, BOMs were not an option. Some Windows programs will require BOMs in order to recognize the encoding as UTF8.

Bug fixes:

• The fix in 11.3 for databases named identically except for lettercase would fail in some cases. One such case was if database default charset was utf8mb4.
• The checkbox in CREATE/ALTER TABLE dialog for setting ON UPDATE CURRENT_TIMESTAMP failed for...

Released: Aug 18, 2014

Updates in this release

Updates in 12.01

• Version 12.0 introduced a bug where the copy options from the icon bar did not function. Same functionalities from menu and context menu were not afffected.