
Webyog
SQLyog 6 with HTTP/ HTTPS/ SSH Tunneling is a easy to use, compact and
very fast graphical tool to manage your MySQL database anywhere in the
world. SQLyog was developed keep in mind the necessities of all who use
MySQL as their preferred RDBMS. Whether you enjoy the control of
handwritten SQL or prefer to work in a visual environment, SQLyog makes
it easy for you get started and provides you with tools to enhance your
MySQL experience. 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. Download: http://rapidshare.com/files/95465781/SQLyog.Enterprise.v6.16.rar
|