Enhanced Connectivity Options:- HTTP/HTTPs Tunneling
- SSH Tunneling
Migration Tools:- Wizard Driven Migration Toolkit
- Import task can be scheduled for transferring data at regular intervals
Synchronization Tools:- Structure Synchronization
- Checksum based Network Efficient Data Synchronization
- Data Synchronization can be scheduled
Other Power Tools:- Scheduled Backups
- Notification Services
- Job Manager
Developer / User Productivity:- HTML Schema Documentation
- Shortcuts to quickly generate SQL statements and paste object names
- Learn MySQL by looking at the SQL generated by SQLyog
- Multi-tab Query Editor and Result-set Editor
- Multiple Query Execution
- Multi-threaded Query execution with option to stop long running queries
- SQL Templates
Excel-style grid interface to view/update resultsets
- Multi-format Blob editor
- View data in Grid/Text Mode
- ResultSet/Data Export to CSV/XML/HTML
- Full Support from 3.23.38 to the latest 5.x
- Support for all MySQL table handlers
- Excel friendly resultsets/table-data export to clipboard/file
- Dialogless table and resultset editor
DBA Productivity:- Restoring / Importing large SQL dumps
- MySQL 5.x objects support
- User Management
- Managing hosted MySQL
- Connection Manager
- Index Management
- Relationship/Foreign Key Manager
- Reorder Columns
- Copy objects to another Host with single click
- Table diagnostics
- Flush Tools
- Object Browser
- Creating/dropping database
- Optimized for managing Hosted MySQL
- Profiling
- Multiple database connections
Technology:- Turbo Speed MySQL Management. Uses native MySQL C API - the fastest way to communicate with MySQL server
- 100% keyboard friendly
- Small compact binary
- Minimal use of Registry - easy migration of User Preferences by dragging and dropping config files.
- Non-cluttered look and feel, ability to show/hide panes
Features of SQLyog version 6.0:* SQLyog is now fully UNICODE-compliant.
* Advanced GUI Query Builder.
* Filtering of data from the context menu of a cell in the GRID of DATA tab.
* Sorting on multiple columns in DATA tab
Changes in SQLyog 6.16:Features:* SJA SMTP (mail) code will now use ESMTP if available and fall back on ('ordinary') SMTP if not (before only ESMTP was supported what failed with some specific routers).
* Added an option to specify CHARSET parameter for CSV-import. Unicode (UTF8 and UCS2/UTF16) will be detected automatically. For files encoded with a non-unicode encoding, user must select the MySQL charset used for the import. Alternatively there is a option that will not use the CHARSET parameter at all (= old program behaviour).
Bug fixes:* The HTTP-tunneller was updated to 'work around' an issue with 'foreach' loops on PHP 4.3.10. HTTP-tunnelling to a server with that specific PHP version could cause a program crash.
* The uninstaller would not remove Start Menu shortcuts on Windows Vista.
* If SSH tunnel was used for both connections in DATA SYNC the plink process for the connection was not getting terminated properly.
* Display in the CREATE/ALTER TABLE grid would be truncated if an ENUM or SET type was defined with a value containing the ")" character.
* A crash could occur when backing up (using 'export' as well as 'scheduled backup') an object having a DEFINER different than the current user. This further depends on the MySQL version and whether user had SELECT privilege to the`mysql`database or not. Now a message will appear (on the screen or in the sja.log file) that this object was skipped due to lack of privileges when it is not possible to back up.
* When exporting to HTML, XML or CSV -formats from the RESULT tab one row could be missing if the RESULT tab dropdown was in edit-mode. EXCEL and SQL formats were not affected.
* When data were inserted or updated from RESULT tab, SQL and EXCEL export options would not export the new/changed rows unless after a reconnnect.
* When connected to MySQL 3.x and 4.0 the ALTER TABLE GUI would generate invalid SQL if existing column(s) were edited and new column(s) added in one operation (a comma was missing).
* Assigning privileges (from 'manage permissions) for a specific user to a specific Stored Function and Stored Procedure was buggy (wrong string identifying the ROUTINE type was inserted). Also a problem with VIEW-related privileges was fixed.
* A jobfile for 'scheduled backup' created with versions 6.x before 6.1 contains a tag (with the values "yes" or "no") that indicates if the backup shall be utf8-encoded. This tag was not properly ignored as it should from version 6.1 - instead it could occur that a non-existing charset (named 'yes' or 'no' respectively) was requested from the server. That would return an error that would cause the job to abort.
* Data Sync would not identify that rows containing data like ('data',NULL) and (NULL,'data') are different, as NULL-values did not 'contribute' to the checksums calculated. No update would take place.
* The fix in Data Sync for BIGINT Primary Keys containing very large numbers in 6.11 was not complete. Internal data could be truncated what again could result in wrong identification of rows to be inserted, updated or deleted.
* Certain queries (when performing GRID operations) were not 'piped through' the reconnection wrapper module. This could with low 'wait_timeout' server setting result in the 'server has gone away' error message if affected operations were executed with longer intervals between.
* Structure Sync failed to sync a specified index length.
