Released: Nov 2, 2023

Updates in v13.2.1

Funktionen

• With the MariaDB server, it is now possible to create a ‘Key’ index on a virtual column using the GUI.
• Emojis will be displayed as is in the ‘Table Data/Result’ tab, ‘Scheduled Backups’, ‘Copy Database To Different Host/Database’ on setting the character set to ‘utf8mb4’ in the ‘Init Command(s)’ field, under the ‘Advanced’ tab of the respective connection and in the Scheduled Backups window.
• The tunneller file for HTTP-tunnel connections has been updated with this release and must be...

Released: Dec 9, 2022

Updates in v13.2.0

Funktionen

• Upgraded the PLINK executable bundled with SQLyog to PuTTY/PLINK v0.77, to support private keys generated in the PPK version 3 file format.

Fehlerkorrekturen

• With Azure DB, SQLyog returned an error “unknown thread id” on stopping the query execution.
• With Azure DB, SQLyog crashed when killing the query from another connection.
• When the ‘CA Certificate’ field is set to empty in a SSL connection, “New Connection Using Current Settings” and “Backup” failed and returned an error after...

Released: Jan 11, 2022

Updates in v13.1.9

Funktionen

• Updated the ‘User Manager’ GUI to support newly added privileges in MariaDB v10.5.

Fehlerkorrekturen

• Changes in SQLyog MySQL13.1.9 GUI include the following bug fixes:
  • SQLyog returned an error when setting user server resources like maximum number of queries per hour, Maximum number of updates per hour, Maximum number of connections per hour, or Maximum number of user connections using User Manager GUI for MySQL v8+ Servers.
  • The tunneler file for HTTP-tunnel has been updated with this...

Released: Apr 29, 2021

Updates in v13.1.8

Fehlerkorrekturen

• With MariaDB System-Versioned tables, SQLyog was hanging when clicking on SQL Preview in the Alter table wizard.
• Indexes were not being displayed with MariaDB System-Versioned tables.
• In some cases, LOAD DATA LOCAL INFILE query failed to be executed from the Query Editor.
• Schema Sync tool generated incomplete queries if the table contained an exceptionally long ENUM data type.
• In some rare cases, Schema Sync failed to sync the mismatch, even after executing the query generated...

Released: Sep 22, 2020

Updates in v13.1.7

Fehlerkorrekturen

• Unable to connect to a MySQL server using SSL when the client doesn’t provide a CA Certificate file, prior to version 10.4.
• When Editing a MySQL user password, the MariaDB server version was not working.
• The Calculate Optimal Datatypes in the Info tab returned syntax error for MySQL version 8 and above.
• When the chunk size was set equal to 0 the Copy Database was not working properly.
• SQLyog returned random errors when importing a SQL dump using HTTP tunnel.
• If the connection...

Released: Apr 30, 2020

Updates in v13.1.6

Funktionen

• An option has been added to specify the authentication plugin while creating/altering the user. This option is available for MySQL 5.7+ and MariaDB 10.4+ servers.
• Now, it is possible to create invisible and descending indexes. This option is available for MySQL 8.0.11+ servers.

Important Note: The 32-bit version has been discontinued from this version.

Fehlerkorrekturen

• In some rare cases, SQLyog failed to connect MySQL over an SSH tunnel.
• The saved connection names longer than...

Released: Apr 5, 2018

Updates in v13.0.0

Funktionen

• Added an option to the ‘Scheduler and Reporting tool’ to attach query result(s) as CSV files.
• Errors returned from queries are now logged to HISTORY tab.
• Added an option to collapse all expanded objects in the Object Browser in a single operation.
• Upgraded Visual Studio build environment from the old 2010 version*.
• Upgraded OpenSSL and SQLite to current versions.
• ‘ROW_FORMAT’ parameter is now handled in the Schema Synchronization comparison.

* Note: The upgrade of Visual Studio means...

Released: Jun 14, 2017

Updates in v12.4.3

Fehlerkorrekturen

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

Released: May 17, 2017

Updates in v12.4.2

Funktionen

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

Fehlerkorrekturen

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

Released: Mar 1, 2017

Updates in v12.4.1

Funktionen

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

Fehlerkorrekturen

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