file handling - SQLyog Ultimate

Notes de publication : The tunneller file for HTTP-tunnel connections has been updated with this release and must be replaced on the server. The 'keywords.db' file (used for syntax highlighting, autocomplete, and automatic ... lettercase handling for functions and keywords) is updated with new keywords and functions added in recent MySQL and MariaDB servers. SQLyog used to abruptly close on altering a table having a column ... On selecting ‘Edit a saved job’ and selecting a job file that has a connection with SSL enabled, the ‘Use SSL Encryption’ checkbox is unchecked, and thus the connection fails. In the Create/Alter Table dialog, ...

Notes de publication : 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 ... as ‘CURRENT_TIMESTAMP()’ in Schema Synchronization tool with MariaDB v10.2+. Fixed- When editing a saved (SJA) job the ‘Email subject line’ could become empty. Also whitespace in the subject line is now handled like ...

Notes de publication : Upgraded the PLINK executable bundled with SQLyog to PuTTY/PLINK v0.77, to support private keys generated in the PPK version 3 file format. With Azure DB, SQLyog returned an error “unknown thread ... tab. Indexes were incorrectly displayed for MySQL v5.1.x and below. Importing an excel file failed when the database collation was set to utf8mb4. Fixed an issue with SSH connection where SQLyog GUI ... TABLE UI. SQLyog failed to connect to a server through SSH with an Ed25519 encrypted private key. Fixed an HTTP connection failure issue with PHP v8.1. The tunneler file for HTTP-tunnel has been updated ...

Description : Favorites SQLyog Ultimate allows easy access to frequently used SQL scripts. The script files can be stored as files from the SQLyog interface or link to an existing file anywhere where windows can access it- ... on a local drive or a shared network drive. The SQL scripts and the file links can be organized in folder and subfolders. SQLyog gives you a choice between four different connectivity options. No matter ... your results in GRID/TEXT mode. Filter data and resultsets directly form the context menu of a displayed value. Execute (very large) SQL-scripts as batch files. Execute multiple queries returning more ...

Description : Favorites SQLyog Ultimate allows easy access to frequently used SQL scripts. The script files can be stored as files from the SQLyog interface or link to an existing file anywhere where windows can access it- ... on a local drive or a shared network drive. The SQL scripts and the file links can be organized in folder and subfolders. SQLyog gives you a choice between four different connectivity options. No matter ... your results in GRID/TEXT mode. Filter data and resultsets directly form the context menu of a displayed value. Execute (very large) SQL-scripts as batch files. Execute multiple queries returning more ...

Notes de publication : 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 release and must be replaced on the server. ... In the old tunneler file, curly braces were used for accessing array elements and string offsets; this behavior is deprecated. Functions used that were deprecated in PHP 7.4x have been addressed In some rare ...

Notes de publication : 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 ...

Notes de publication : at a 10-digit number. Import from Excel did not handle cells with multiline text properly. A linebreak became a SPACE. For a non read-only connection, on right-clicking on a table, the Import External Data option ... was greyed out even though it could be accessed from the Powertools and shortcut key. The ‘date picker’ did not handle dates with a ZERO-day/month/year (as allowed in specific sql_modes). In such cases current ...

Notes de publication : Introduces a new feature- REGEX search in Object Browser, plus bug fixes. Search function in Object Browser now supports regular expressions. Important Notice: The tunneler file for HTTP-tunnel has ...

Notes de publication : 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. ...

Notes de publication : Dump” when selecting ‘Data Only’ option, it was possible to select objects not containing data. This case is now handled more intuitive. At the bottom of the Object Browser there is a notification area ... This has now been removed from the templates. When deleting a connection tab the focus was not handled correctly in some cases, where it would highlight one connection tab and display the contents of another ...

Notes de publication : 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 ...

Notes de publication : 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. ...

Notes de publication : file could be locked and thus could not be edited in a text editor for instance. ...

Notes de publication : possible to save current setting of Visual Data Compare in a job file. This job file will be compatible with Data Sync (ie. a job file generated by one may be used with the other and vice versa). 'copy ...

Notes de publication : and privacy of the cloud is enforced by using SSL for internal communication in the cloud. Multiple files (.sql,.schemaxml,.queryxml) may now be opened in one operation in main editor window. Bug Fixes: When ...

Notes de publication : 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 ...

Notes de publication : 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 ...