Webyog SQLyog Ultimate 8.32 | 14.26 MBWebyog SQLyog 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.
SQLyog MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL Front Ends and MySQL clients in a single intuitive interface.
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
Changes in SQLyog 8.3 (March 2010):
Features
* Added an option to define a ‘color code’ for a connection. The color will be used as background color in the Object Browser.
* A Query Builder session can now be saved and resumed.
* In Query Builder a table alias can be defined for any table by double-clicking the title bar of the table symbol.
* In RESULT tab results can now be retrieved page-wise. This is ON as default with this build with a defined LIMIT of 1000 rows. For a specific query user can change and for this specific query the setting is persistent across sessions. Also read ‘miscellaneous’ paragraph below.
* Added a context menu to Query Builder canvas.
Bug Fixes
* Deleting a user would leave non-global privileges orphaned in the ‘mysql’ database. Now we use DELETE USER syntax if server supports.
* Also using EDIT USER dialogue to change host or user specifier for a user would not move non-global privileges. We have split the old ALTER USER dialogue into two: a EDIT USER and RENAME USER dialogue. The latter will use RENAME USER syntax if server supports.
* On Wine Data Sync could generate a malformed XML-string what would case Data Sync to abort.
* Fixed an issue where SSH-tunneling failed with public/private key authentication. Technically the fix is in the PLINK binary shipped with SQLyog.
* SJA failed to send notification mails if Yahoo SMTP servers were used. Note that the fix disables encryption option with Yahoo SMTP servers – but it won’t work anyway due to a non-standard SMTP implementation server-side.
* When importing data from a Universe ODBC-source string data could be truncated.
* The fix in 8.22 for the issue that horizontal scrollbar in GRID would sometime not appear was not complete. It could still happen.
* SQLyog will now trim trailing whitespaces in Connection Manager and Create object dialogs to avoid MySQL Errors.
* Opening a file from ‘recent files’ list could crash SQLyog if a Query Builder or Schema Designer tab was selected and the file specified was not a valid XML file for that tab. This bug was introduced in beta 1.
* When calling a Stored Procedure with more than one SELECT statement from ‘Notifications Services’ only one result set was sent by mail.
* The sja.log file had no line-breaks between what was recorded for two jobs.
* On multi-monitor system resizable dialogues could open on the wrong monitor. New implementation is like this: on multi-monitor systems main program dialogue and ‘first child dialogue’ (example: ALTER TABLE) will open where they were closed (if possible), second and higher child dialogues (example: table advanced properties) will always open on top of its ‘parent’ dialogue. Non-resizable dialogues (such as confirmation boxes) will always open on top of their ‘parent’.
* With multiple SSH-tunnelled connections open stopping and re-executing queries in multiple connections in a fast manner could crash SQLyog.
* If more than one comment occurred before a SELECT statement in the editor, the statement was not identified as a SELECT statement by the Query Profiler and the Query Profiler TAB would not display.
* We did not validate client-side if user checked atoincrement option for a bit column with Create/Alter table dialog.
* If an error occurred while renaming a trigger then trigger was lost as SQLyog was not recreating it back.
* Small GUI fixes.
Miscellaneous
* The default LIMIT setting for DATA tab has been removed. The setting is not required since we introduced table-level persistence for number of rows displayed. The default for new tables that have not been opened before is 50 – but when user changes the value and next ‘refresh’es SQLyog will save the LIMIT for that particular table persistently across sessions. This in combination with page-wise display in RESULT tab results in a more uniform User Interface for DATA and RESULT tabs.
DOWNLOAD
DEPOSITFILES
HOTFILE
