Released: May 26, 2016

Updates in this release

Updates in 12.2.3

Features:

• User Manager filter: when some characters are typed for user in User Manager first match with same starting characters will be selected.

Bug Fixes:

• "Ignore Definer" did not work if "Drop Table if exist" and "Ignore Definer" both were ticked in cases where only procedures and/or functions were copied to another database.
• The result of a multiline string in text mode displayed empty in case where the string started with a line break.
• For "wide" BIT(n) types "0"-bits...

Released: May 5, 2016

Updates in this release

Updates in 12.2.2

Features:

• The 'date picker' now has a GUI control to insert current date.
• When running multiple statements in the editor and an error occured, SQLyog would continue to next statement. There is now an option to 'halt on error' in such cases.

Bug Fixes:

• The 'sys' database of MySQL 5.7 was erroneously backed up when choosing 'all databases' in the Scheduled Backup tool.
• Table-level comments were truncated at 490 characters.
• The 'date picker' calender could display distorted in...

Released: Feb 25, 2016

Updates in this release

Updates in 12.2.1

Bug Fixes:

• Updates from RESULT tab could fail with MySQL 4.1 servers. The recent code changes in order to support MySQL 5.7 Virtual Columns overlooked that there is no Information_Schema database in MySQL 4.1 and a required condition could not be verifed due to this.
• In rare cases "copy database to a different host" option could generate incorrect statements and copying would fail with a 'columns count mismatch' error. Also this was introduced with code changes in order to...

Released: Feb 12, 2016

Updates in this release

Updates in 12.2.0

Bug Fixes:

• Virtual Columns of MySQL 5.7 were not handled properly in 'copy database to other host'.
• 12.1.9 introduced a sluggishness when moving around the data GRID. In some cases it could be so bad that the program seemed to "hang" completely.

Miscellaneous:

• Fixed inconsistent versioning. Earlier we could sometimes use format like “11.19″ and sometimes “12.1.9″. We now consistently use the latter – like "12.2.0" with this release.

Released: Feb 9, 2016

Updates in this release

Updates in 12.19

Features:

• Virtual Columns support for MySQL 5.7 onwards (Virtual Columns with MariaDB were already supported). Please see note below for details.
• SSL and SSH-tunnel are now not mutually exclusive. A SSL connection may now be established through an SSH-tunnel. This is in particular useful with various sorts of "private clouds" where connection to the cloud requires SSH and privacy of the cloud is enforced by using SSL for internal communication in the cloud.
• Multiple files (.sql...

Released: Dec 29, 2015

Updates in this release

Updates in 12.18

Bug Fixes:

• In 12.17 (released yesterday) it could happen that session restore erroneously could restore (a) Query tab(s) from previous session that was closed before SQLyog itself was closed.

Released: Dec 28, 2015

Updates in this release

Updates in 12.17

Bug Fixes:

• Fixed a memory leak as well as a crash in 'session restore' when writing a restore point. This was reported by a number of users. We were never able to reproduce these issues ourselves but a number of affected users have tested and confirmed the fix.
• The formatter could add trailing space after specific keywords occuring at the end of a line.
• In CSV exports there was an additional comma after each row while exporting a table if the last column was not selected for...

Released: Nov 3, 2015

Updates in this release

Updates in 12.16

Features:

• Schema Designer may now optionally use 'portrait' or 'landscape' layout for printing. Before only 'portrait' was available. Also page breaks may now be previewed.

Bug Fixes:

• With 'ChallengeResponseAuthentication' set to "YES" in SSHD configuration, SSH tunnel from SQLyog would fail. This was introduced in 12.13 with the PLINK update here.
• On Wine the color palette used for customizing colors of the SQLyog interface did not open.
• In the Connection Manager .. MySQL tab...

Released: Oct 7, 2015

Updates in this release

Updates in 12.15

Features:

• The search for the connections and databases is now faster and simpler, as it lists all the connections and databases which contain the typed phrase.

Bug Fixes:

• Schema synchronisation tool now functions by creating dummy tables in cases where views are built on another views.
• Earlier SQLyog updated connrestore.db file even when there were no changes in the current session. This is now fixed.

Released: Aug 26, 2015

Updates in this release

Updates in 12.14

Features:

• Added an option in "Export as SQL Dump", "Export Table Data As.." and "Scheduled Backup" not to write the SQLyog version to SQL dumps. This will reduce 'noise' for users comparing dumps for auditing purposes, when SQLyog has been upgraded.
• In both "Export as SQL Dump", and "Scheduled backup" there is now an option to add a linebreak between rows if BULK INSERTS are written. This will increase readability and help to prevent truncation of lines if the dump is opened in...